TM1 Function for TI, ​​HierarchyExists

Checks whether a specific hierarchy exists in a dimension.

What is the HierarchyExists function?

HierarchyExists checks whether a specific hierarchy exists in a dimension. If the hierarchy exists, the result is 1 and if it does not exist the result is 0.

Where can the HierarchyExists function be used?


What is the syntax for HierarchyExists?

HierarchyExists(DimName, HierName);

DimName = Dimension Name​
HierName = Element Name

A demonstration on how to use HierarchyExists

Check whether the United Kingdom hierarchy exists in Sales Region dimension.