All eazyBI for Jira eazyBI for Confluence Private eazyBI

Hierarchy

Returns the hierarchy that contains a specified member or level.

Syntax

Member_Expression.Hierarchy

or

Level_Expression.Hierarchy

Arguments

Member_ExpressionMDX expression that returns a member.
Level_ExpressionMDX expression that returns a level.

Examples

The Time dimension has several hierarchies. The formula [Time].CurrentHierarchy.Levels("Day").CurrentDateMember will pull in the current date member representing Today no matter what hierarchy is used in the report.

See the example report Issues due and overdue in our demo account. The calculated measure Overdue issues uses the formula to retrieve Today and count any unresolved issues with due date before Today. 

See also