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 timeline it will pull in a data member representing Today. For month on timelime it will pull in a member representing current month. 


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

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