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
Which TM1 Server version is this function available for?
Version 11 and 12
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.