Skip to content

tupletostr-mdx.md

Latest commit

 

History

History
60 lines (46 loc) · 1.54 KB

tupletostr-mdx.md

File metadata and controls

60 lines (46 loc) · 1.54 KB
title TupleToStr (MDX)
description TupleToStr (MDX)
ms.date 02/17/2022
ms.service sql
ms.subservice analysis-services
ms.topic reference
ms.custom mdx

TupleToStr (MDX)

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

Syntax

  
TupleToStr(Tuple_Expression)

Arguments

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

Remarks

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]

See Also

MDX Function Reference (MDX)