TM1 Function for Rules, ELISPAR
ELISPAR determines if an element is parent of another element or not.
Where can the ELISPAR function be used?
Excel, Rules and TurboIntegrator
What is the ELISPAR function?
ELISPAR determines if an element is parent of another element or not.
What is the syntax for ELISPAR?
ELISPAR(dimension, element1, element2)
Dimension = A dimension name.
Element1= The name of a consolidated element.
Element2 = The name of an element.
A demonstration on how to use ELISPAR
Use ELISPAR function to determine if the ‘All Products by Category’ element is parent or another elements or not and apply it in the rule to populate the Comment measure in the Product Scorecard cube.