Skip to main content
Skip table of contents

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

CODE
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
SetToStr(
 Filter(
  [Customer].[Customer].Members,
  [Measures].[Item base amount] < 1000
 )
)
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.