Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
The following example returns the name of the Calendar hierarchy in the Date 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]
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today