All eazyBI for Jira eazyBI for Confluence Private eazyBI

Level

Returns the level of a member.

Syntax

 Member_Expression.Level

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

This example formula [Time].CurrentHierarchy.Level will address the particular level of the selected time member. You can use it to check what level it is or use the level to create a current date member:  

[Time].CurrentHierarchy.Level.CurrentDateMember

The formula above will retrieve a member representing the current period on a specific level. For days on the timeline, it will pull in a data member representing Today. For a month on timelime it will pull in a member representing the current month. 


Use the following formula to calculate report results only for a certain level from a dimension using CASE and CoalesceEmpty functions.

CASE WHEN
  [Time].CurrentHierarchy.Level.Name = 'Year'
THEN
  CoalesceEmpty([Measures].[YTD sales EUR], 0)
END