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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book