All eazyBI for Jira eazyBI for Confluence Private eazyBI

CurrentHierarchyMember

EAZYBI Returns current dimension hierarchy member based on currently used hierarchy.

Syntax

Dimension_Expression.CurrentHierarchyMember

Arguments

Dimension_ExpressionMDX expression that returns a dimension.

Examples

[Time].CurrentHierarchyMember can be used in calculated member formulas to handle both [Time].CurrentMember and [Time.Weekly].CurrentMember cases.

Example below verifies if the Time dimension is used on report with a particular period or not used in the report. The formula validates if All Times (default member) is used in the report or Time dimension is absent from the report. 

[Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember

See example report Control chart (cycle time) in our Demo account. Time dimension usage in the report might impact calculation. The calculated measures Rolling Average cycle time and Rolling Average cycle time alternative uses a formula above to validate if the Time dimension is used in the report. If no time dimension is used in the report a simple calculation for a cycle time can be used. The report uses Time dimension in the report, therefore, in the particular example the more complex calculation with iteration through issues is needed. 

See also