回傳維度、階層、層級或成員的名稱。
Syntax
Dimension expression syntax
Dimension_Expression.Name
Hierarchy expression syntax
Hierarchy_Expression.Name
Level_expression syntax
Level_Expression.Name
Member expression syntax
Member_Expression.Name
論點
Dimension_Expression
一個有效的多維表達式(MDX)表達式,能回傳一個維度。
Hierarchy_Expression
一個有效的多維表達式(MDX)表達式,能回傳階層結構。
Level_Expression
一個有效的多維表達式(MDX)表達式,能回傳一個層級。
Member_Expression
一個有效的多維表達式(MDX)表達式,回傳成員。
備註
Name 函式回傳的是物件名稱,而非唯一名稱。
Examples
維度、階層與層級表達範例
以下範例回傳日期維度的維度名稱,以及 2001 年 7 月成員的階層與層級名稱。
WITH MEMBER Measures.DimensionName AS [Date].Name
MEMBER Measures.HierarchyName AS [Date].[Calendar].[July 2001].Hierarchy.Name
MEMBER Measures.LevelName as [Date].[Calendar].[July 2001].Level.Name
SELECT {Measures.DimensionName, Measures.HierarchyName, Measures.LevelName} ON 0
from [Adventure Works]
成員表達範例
以下範例會回傳成員名稱,以及成員值、成員金鑰和成員說明。
WITH MEMBER MemberName AS [Date].[Calendar].[July 1, 2001].Name
MEMBER Measures.ValueColumn as [Date].[Calendar].[July 1, 2001].MemberValue
MEMBER Measures.KeyColumn as [Date].[Calendar].[July 1, 2001].Member_Key
MEMBER Measures.NameColumn as [Date].[Calendar].[July 1, 2001].Member_Name
SELECT {Measures.MemberName, Measures.ValueColumn, Measures.KeyColumn, Measures.NameColumn} ON 0
from [Adventure Works]