Excel Functions

TM1 Function – ELLEV

Available In

Excel

Definition

ELPAR returns an element’s level in the dimension.

Syntax

ELLEV(TM1ServerName:Dimension, Element)

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

Example

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