Level
Returns the level of a member.
Syntax
Member_Expression.Level
Arguments
Member_Expression | MDX 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