DNLEV

DNLEV returns the number of hierarchy levels in a dimension.

Syntax

DNLEV(server:dimension)

Argument	Description	Required/Optional
server:dimension	The name of the TM1® server and a dimension name.	Required

Example

This example uses the TM1 server SData and a dimension called Region. In the Region dimension, the various nations (Level 0) add up to regions (Level 1). The regions then add up to super-regions (Level 2), which in turn add up to the world (Level 3).

DNLEV("SData:Region")

Diagram of the Region dimension where Level 0 has nations, level 1 has regions, level 2 has super-regions, and level 3 contains one member, World.

The region dimension has four hierarchy levels (0, 1, 2, and 3). Therefore, in this example the function returns 4.