Rule Functions

TM1 Function for Rules – HIERARCHYN

Available In

Rules

Definition

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

Syntax

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.