Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

Hierarchy (MDX)

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]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft