TI Functions

TM1 Function for TI – ​​​​​​​​​​​HierarchyContainsAllLeaves

Available In



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).


HierarchyContainsAllLeaves (DimNameHierName)

DimName = Dimension Name

HierName = Hierarchy Name

Video Demo

Validate Western Europe hierarchy in the Sales Region dimension, if it has all leaf elements in the dimension or not.