HierarchyHasOrphanedLeaves
HierarchyHasOrphanedLeaves returns an integer that represents the number of members in the specified hierarchy that are not components of a parent member in that hierarchy (that is, orphaned leaves). If there are no members, 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.