ELLEV

ELLEV returns the level of a member within a dimension.

Syntax

ELLEV(server:dimension, element)

Argument	Description	Required/Optional
server:dimension	The name of the TM1® server and a dimension name.	Required
element	The name of a member within the dimension. This argument can also be the name of an alias for a dimension member.	Required

Example

These examples use the TM1 server SData and a dimension called Region. In the Region dimension, individual 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).

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.

ELLEV("SData:region","Norway")

In this example, the function returns 0 because Norway is a leaf level member of the Region dimension.

ELLEV("SData:region ","Scandinavia")

In this example, the function returns 1 because Scandinavia is a Level 1 member of the Region dimension.

ELLEV("SData:Region","Europe")

In this example, the function returns 2 because Europe is a Level 2 member of the Region dimension.