If a hierarchy contains all leaf elements in the dimension.
What is the HierarchyContainsAllLeaves function?
HierarchyContainsAllLeaves validates if a hierarchy contains all leaf elements in the dimension. If all are leaf elements the function returns 1 (True) and if missing one or more leaf elements it returns 0 (false).
Where can the HierarchyContainsAllLeaves function be used?
TurboIntegrator
What is the syntax for HierarchyContainsAllLeaves?
HierarchyContainsAllLeaves (DimName, HierName);
DimName = Dimension Name
HierName = Hierarchy Name
A demonstration on how to use HierarchyContainsAllLeaves
Validate Western Europe hierarchy from the Sales Region dimension, if it has all leaf elements in the dimension or not.
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