DIM.TOPLEVEL
In a dimension hierarchy, base elements are considered level 0. All further levels are
calculated from this level upwards. So, the first level of consolidated elements is level 1,
the second level 2 and so on.
DIM.TOPLEVEL returns the
level number of the highest element in the consolidation hierarchy of a dimension. Syntax
DIM.TOPLEVEL(Dimension)
Dimension is the name of the dimension
whose highest hierarchy level you want to determine.
Example
In the REGION dimension, All Regions is the highest level element at level 4. This example returns 4:
DIM.TOPLEVEL('Regions')