TupleToStr(MDX)

回傳一個多維表達式(MDX)格式的字串,對應於指定的元組。

Syntax

  
TupleToStr(Tuple_Expression)   

論點

Tuple_Expression
一個有效的多維表達式(MDX)表達式,回傳元組。

備註

此函式用於將元組的字串表示轉移到外部函數進行解析。 回傳的字串以大括 {} 號包圍,若元組中明確定義多個成員,則以逗號分隔。

Examples

以下範例回傳字串 ([Date].[日曆年].&[2001],[地理]。[地理]。[鄉村音樂]。&[美國])

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

以下範例回傳與前一個範例相同的字串。

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]