Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

TupleToStr (MDX)

Returns a Multidimensional Expressions (MDX)–formatted string that corresponds to a specified tuple.

TupleToStr(Tuple_Expression) 

Tuple_Expression

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

This function is used to transfer a string-representation of a tuple to an external function for parsing. The string that is returned is enclosed in braces {} and each member, if more than one is expressly defined in the tuple, is separated by a comma.

Examples

The following example returns the string ([Date].[Calendar Year].&[2001],[Geography].[Geography].[Country].&[United States]) :

WITH MEMBER Measures.x AS TupleToStr 
   ( 
      ([Date].[Calendar Year].&[2001]
         , [Geography].[Geography].[Country].&[United States]
      )
   )   
SELECT Measures.x ON 0
FROM [Adventure Works]

The following example returns the same string as the previous example.

WITH SET s AS 
   {
      ([Date].[Calendar Year].&[2001],
         [Geography].[Geography].[Country].&[United States]
      ) 
   }
MEMBER Measures.x AS TupleToStr ( s.Item(0) )
SELECT Measures.x ON 0
FROM [Adventure Works]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft