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')