TM1 Function for Rules,​ ELPAR

ELPAR returns the parent of an element. 

Where can the ELPAR function be used?

Excel, Rules and TurboIntegrator

What is the ELPAR function?

​ELPAR returns the parent of an element.   

What is the syntax for ELPAR?

ELPAR(dimension, element, index)​​
Dimension = A dimension name.​
Element = The name of an element name​
Index = Position number.

A demonstration on how to use ELPAR

Use ELPAR function to retrieve element’s parent name and apply it in the rule to populate in the Product Scorecard cube.