All eazyBI for Jira eazyBI for Confluence Private eazyBI

Hierarchy

Returns the hierarchy that contains a specified member or level.

Syntax

Member_Expression.Hierarchy
 
Level_Expression.Hierarchy

Arguments

Member_ExpressionA valid Multidimensional Expressions (MDX) expression that returns a member.
Level_ExpressionA valid Multidimensional Expressions (MDX) expression that returns a level.

Examples

 The dimension Time 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 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