Constructs a string from the set. The string contains member names that correspond to a specified set. This is a useful function to validate the MDX calculation and see which members are included in the set.
Syntax
SetToStr( Set_Expression )
Arguments
| Set_Expression | MDX expression that returns a set of members. |
|---|
Returns
String_Expression | String expression representing member names. |
|---|
Examples
The following example returns filtered Customers that have less than 1000 Item base amount.
SetToStr(
Filter(
[Customer].[Customer].Members,
[Measures].[Item base amount] < 1000
)
)