Rule Functions

TM1 Function for Rules – HIERARCHYN

Available In



HIERARCHYN returns the name of the hierarchy at a specified position. 


HierarchyN(DimName, Index);

DimName =  Dimension name.

Index  = A value less than or equal to the number of hierarchies in the dimension.

Video Demo

Use HierarchyN function to retrieve Employee Hierarchies dimension hierarchies name and apply it in the rule to populate in the Employee Salaries cube.