<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

TM1 Function for Rules,​ ELPAR

ELPAR returns the parent of an element.

Where can the ELPAR function be used?

Excel, Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

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.