SetToStr
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

SetToStr (MDX)

Updated: 17 July 2006

Returns a Multidimensional Expressions (MDX)-formatted string of that corresponds to a specified set.


SetToStr(Set_Expression)

Set_Expression

A valid Multidimensional Expressions (MDX) expression that returns a set.

This function is used to transfer a string-representation of a set to an external function for parsing. The string that is returned is enclosed in braces {} and separated by a comma.

Example

The following example returns a string containing all of the members of the Geography.Country attribute hierarchy.

WITH MEMBER Measures.x AS SetToStr (Geography.Geography.Children)
SELECT Measures.x ON 0
FROM [Adventure Works]

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
Show:
© 2016 Microsoft