TM1 Function for Excel, ELLEV
ELLEV returns an element’s level in the dimension.
Where can the ELLEV function be used?
Excel, Rules and TurboIntegrator
What is the ELLEV function?
ELLEV returns an element’s level in the dimension.
What is the syntax for ELLEV?
ELLEV(TM1ServerName:Dimension, Element)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = Name of the element
A demonstration on how to use ELLEV
From the Product Type dimension, get the consolidation All Products by Category and its descendants to get each element’s level.