TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​HierarchyHasOrphanedLeaves

Available In

TurboIntegrator

Definition

​HierarchyHasOrphanedLeaves returns 1 if a hierarchy in a dimension has an orphaned element or returns 0 if there is no orphaned element in that hierarchy.

Syntax

HierarchyHasOrphanedLeaves(DimensionName, HierarchyName);​

​DimensionName = Name of the dimension to be checked​

HierarchyName = Name of the Hierarchy to be checked​

Note: The return value is a Numeric value

Video Demo

Use HierarchyHasOrphanedLeaves tp see of there are any orphaned elements in the Employee Hierarchies dimension.