Document toolboxDocument toolbox

SetToStr

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