回傳一個多維表達式(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]