HierarchyHasOrphanedLeaves
HierarchyHasOrphanedLeaves returns 1 if there are one or more members in the specified hierarchy that are not components of a parent member in that hierarchy. Otherwise, the function returns 0.
This function is valid in TurboIntegrator processes only.
Syntax
HierarchyHasOrphanedLeaves(DimName, HierName);|
Argument |
Description |
|---|---|
|
DimName |
The name of the dimension that contains the hierarchy being reviewed. |
|
HierName |
The name of the hierarchy you are reviewing for orphaned leaf members. |
Example
HierarchyHasOrphanedLeaves('Region', 'Europe');This example determines if the Europe hierarchy, in the Region dimension, contains any orphaned leaves.