DE.LEVEL

Returns the level of a specified element in a dimension hierarchy. In a dimension hierarchy, base elements (Types of element) are at level 0. All further levels are calculated from this level upwards. So, the first level of consolidated elements is level 1, the second is level 2, etc.

Syntax

DE.LEVEL(Database alias,Dimension,Element)

Dimension is the name of the dimension containing the element whose level you want to determine and Element is the element.

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

If an element does not exist or is not a member of the Dimension, the function returns a #Value error.