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(DimNameHierNameElName)

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.