Rule Functions

TM1 Function for Rules – ELEMENTISANCESTOR

Available In

Rules and TurboIntegrator

Definition

ELEMENTISANCESTOR determines if the element is an ancestor of another element or not. Function returns 1 if the element is ancestor of another element

Syntax

ElementIsAncestor(dimension, hierarchy, element1, element2)

Dimension = A dimension name.

Hierarchy = The name of the hierarchy.

Element1= The name of a consolidated element. 

Element2 = The name of an element.

Video Demo

Use ElementIsAncestor function to determine if the consolidation element is an ancestor of another element or not and apply it in the rule to populate the Comment measure in the Employee Salaries cube.