TM1 Function for TI, 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.
What is the HierarchyHasOrphanedLeaves function?
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.
Where can the HierarchyHasOrphanedLeaves function be used?
TurboIntegrator
What is the syntax for HierarchyHasOrphanedLeaves?
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
A demonstration on how to use HierarchyHasOrphanedLeaves
Use HierarchyHasOrphanedLeaves to see if there are any orphaned elements in the Employee Hierarchies dimension.