TI Functions
TM1 Function for TI – HierarchyElementExists
Available In
TurboIntegrator
Definition
HierarchyElementExists checks whether an element exists in a dimension. If the element exists, the result is 1. If it does not exist, the result is 0.
Syntax
HierarchyElementExists(DimName, HierName, ElName)
DimName = Dimension Name
HierName = Hierarchy Name
ElName = Element Name
Video Demo
Check if Wales exists in the United Kingdom hierarchy from the Sales Region dimension.