TM1 Function for Rules, ELISANC
ELISANC determines if an element is ancestor of another element or not.
Where can the ELISANC function be used?
Rules and TurboIntegrator
What is the ELISANC function?
ELISANC determines if an element is ancestor of another element or not.
What is the syntax for ELISANC?
ELISANC(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 ELISANC
Use ELISANC function to determine if the ‘Accessories’ consolidation is an ancestor or another element or not and apply it in the rule to populate the Comment measure in the Product Scorecard cube.