Rule Functions

TM1 Function for Rules – HIERARCHYINDEX

Available In

Rules

Definition

HIERARCHYINDEX function returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.

Syntax

HierarchyIndex(DimNameHierName);

DimName =  Dimension name.

HierName  = A valid hierarchy name.

Video Demo

Use HierarchyIndex function to retrieve dimension hierarchy index value and apply it in the rule to populate in the Employee Salaries cube.