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.