DE.LEVEL
Returns the level in the dimension hierarchy of a specified element. In a dimension
hierarchy, base elements are at level 0. All further levels are calculated from this level
upwards. For example, the first level of consolidated elements is level 1, the second is level
2, and so on.
Syntax
DE.LEVEL(Dimension, Element)
Examples
In the REGION dimension, Bayern and Berlin consolidate into Germany. Germany consolidates into Europe. This example returns 0:
DE.LEVEL('Region', 'Berlin')
This example returns 2:
DE.LEVEL('Region', 'Europe')