Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

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

Code Block
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.

Code Block
SetToStr(

...


 Filter(

...


  [Customer].[Customer].Members,

...


  [Measures].[Item base amount] < 1000

...


 )

...


)