Excel Functions

TM1 Function – DNLEV

Available In

Excel

Definition

DNLEV returns the number of levels in a dimension.

Syntax

DNLEV(TM1ServerName:Dimension)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension

Example

Return the number of levels in the Account dimension.

In the ‘Account’ dimension, there a six levels.

In Excel:

DNLEV(“AdventureWorks:Account”) returns 6 levels.

Video Demo