DIM.TOPLEVEL
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, level 2, etc.
DIM.TOPLEVEL returns the level number of the highest element in the consolidation hierarchy of a dimension.
Syntax
DIM.TOPLEVEL(Database alias,Dimension)
Dimension is the name of the dimension whose highest hierarchy level you want to determine.
Example
In the Product dimension of the Best Practices sample database, All Tires is at level 3. This formula returns "3":
DIM.TOPLEVEL("Best Practices OLAP","Product")
Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.
If a non-existent dimension is entered, the function returns a #Value error.