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