Excel Functions

TM1 Function – ELLEV

Available In



ELPAR returns an element’s level in the dimension.


ELLEV(TM1ServerName:Dimension, Element)

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


From the Product Type dimension, get the consolidation All Products by Category and its descendants to get each element’s level.

In the ‘Product Type’ dimension, this is the consolidation ‘All Products by Category’.

Copy and paste the element names into Excel.

In Excel:

ELLEV(“AdventureWorks:Product Type”, A1)

e.g. ELLEV(“AdventureWorks:Product Type”, “All Products by Category”)

The query returns ‘2’.

Copy the formula down to apply the formula to all elements.

Video Demo