Name(MDX)Name (MDX)

이 항목은 다음에 적용됩니다.예SQL Server(2008부터)아니요Azure SQL Database아니요Azure SQL Data Warehouse 아니요병렬 데이터 웨어하우스 THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

차원, 계층, 수준 또는 멤버의 이름을 반환합니다.Returns the name of a dimension, hierarchy, level, or member.

구문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  

인수Arguments

Dimension_ExpressionDimension_Expression
차원을 반환하는 유효한 MDX(Multidimensional Expressions) 식입니다.A valid Multidimensional Expressions (MDX) expression that returns a dimension.

Hierarchy_ExpressionHierarchy_Expression
계층을 반환하는 유효한 MDX 식입니다.A valid Multidimensional Expressions (MDX) expression that returns a hierarchy.

Level_ExpressionLevel_Expression
수준을 반환하는 유효한 MDX 식입니다.A valid Multidimensional Expressions (MDX) expression that returns a level.

Member_ExpressionMember_Expression
멤버를 반환하는 유효한 MDX 식입니다.A valid Multidimensional Expressions (MDX) expression that returns a member.

주의Remarks

이름 함수가 고유 이름이 아니라 개체의 이름을 반환 합니다.The Name function returns the name of the object, not the unique name.

Examples

차원, 계층 및 수준 식 예Dimension, Hierarchy and Level Expression Example

다음 예에서는 Date 차원의 차원 이름과 July 2001 멤버의 계층 및 수준 이름을 반환합니다.The following example returns the dimension name for the Date dimension and the hierarchy and level names for the July 2001 member.

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]  

멤버 식 예Member Expression Example

다음 예에서는 멤버 값, 멤버 키 및 멤버 캡션과 함께 멤버 이름을 반환합니다.The following example returns the member name, along with the member value, member key and member caption.

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]  

참고 항목See Also

MDX 함수 참조 ( Mdx)MDX Function Reference (MDX)