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(DimensionNameHierarchyName);

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.