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_ExpressionMDX 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
)
)