TM1 Function for TI, HierarchyElementExists

Checks whether an element exists in a dimension.

What is the HierarchyElementExists function?

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.

Where can the HierarchyElementExists function be used?


What is the syntax for HierarchyElementExists?

HierarchyElementExists(DimName, HierName, ElName);

DimName = Dimension Name
HierName = Hierarchy Name
ElName = Element Name

A demonstration on how to use HierarchyElementExists

Check if Wales exists in the United Kingdom hierarchy from the Sales Region dimension.