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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book