TM1 Function for Rules,​ ELLEV

ELLEV returns the level of an element within a dimension.

Where can the ELLEV function be used?

Excel, Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the ELLEV function?

ELLEV returns the level of an element within a dimension.

What is the syntax for ELLEV?

ELLEV (dimension, element)​ ​
Dimension = A dimension name.​
Element = The name of an element.

A demonstration on how to use ELLEV

Use ELLEV function to retrieve element’s level and apply it in the rule to populate in the Product Scorecard cube.