<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

TM1 Function for Rules, HIERARCHYCOUNT

HIERARCHYCOUNT returns the number of hierarchies in the supplied dimension.

Where can the HIERARCHYCOUNT function be used?

Rules

Which TM1 Server version is this function available for?

Version 11 and 12

What is the HIERARCHYCOUNT function?

HIERARCHYCOUNT returns the number of hierarchies in the supplied dimension.

What is the syntax for HIERARCHYCOUNT?

HierarchyCount(DimName);​
​DimName =  Dimension name.

A demonstration on how to use HIERARCHYCOUNT

Use HierarchyCount function to retrieve Employee Hierarchies dimension number of hierarchy and apply it in the rule to populate in the Employee Salaries cube.