Hierarchy (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the hierarchy that contains a specified member or level.

Syntax


Member expression syntax  
Member_Expression.Hierarchy  

Level expression syntax  
Level_Expression.Hierarchy  

Arguments

Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.

Level_Expression
A valid Multidimensional Expressions (MDX) expression that returns a level.

Examples

The following example returns the name of the Calendar hierarchy in the Data dimension in the AdventureWorks cube.

WITH

MEMBER Measures.HierarchyName as

[Date].[Calendar].Currentmember.Hierarchy.Name

SELECT {Measures.HierarchyName} ON 0,

{[Date].[Calendar].[All Periods]} ON 1

FROM [Adventure Works]

See Also

MDX Function Reference (MDX)