TM1 Function for TI, HierarchyContainsAllLeaves
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.