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
Which TM1 Server version is this function available for?
Version 11 and 12
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.