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.