Rule Functions

TM1 Function for Rules – ELEMENTISCOMPONENT 

Available In

Rules and TurboIntegrator

Definition

​ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.  Function returns 1 if the element is child of consolidation. 

Syntax

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.

Video Demo

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.