TechNet
Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content
Expand Minimize

Hierarchy (MDX)

 

Updated: March 2, 2016

Returns the hierarchy that contains a specified member or level.

  
Member expression syntax  
Member_Expression.Hierarchy  
  
Level expression syntax  
Level_Expression.Hierarchy  

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]

MDX Function Reference (MDX)

Community Additions

ADD
Show:
© 2016 Microsoft