fbpx

SetToStr (MDX)

Returns a string with the members of the set concatenated using their unique name.

Parameters

Name Type Cardinality Default value
  set-expression  one   

Return

string

Description

Returns a string with the members of the set concatenated using their unique name.

The set { [Geography].[Geo].[France], [Geography].[Geo].[United States] } is transformed into this string :

"{[Geography].[Geo].[Country].&[FR],[Geography].[Geo].[Country].&[US]}"

Note there is no guarantee how the unique name is going to be generated (e.g. using keys). You can use Generate function to have a better control on how exactly the resulting string should be.

See Also

StrToSet Generate

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.