TM1 Function for Rules, ELEMENTISCOMPONENT
ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.
Where can the ELEMENTISCOMPONENT function be used?
Rules and TurboIntegrator
What is the ELEMENTISCOMPONENT function?
ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. Function returns 1 if the element is child of consolidation.
What is the syntax for ELEMENTISCOMPONENT?
ElementIsComponent (dimension, hierarchy, element1, element2)
dimension = A dimension name.
Hierarchy = The name of the hierarchy.
Element1 = The name of the element within dimension.
Element2 = The name of the consolidated element within dimension.
A demonstration on how to use ELEMENTISCOMPONENT
Use ElementIsComponent function to determine if an element is child of a consolidation or not and apply it in the rule to populate the Comment measure in the Employee Salaries cube.