HierarchyN

HierarchyN returns the name of the hierarchy at a specified position in the supplied dimension and an empty string if the index is out of scope. HierarchyN is valid in rules only.

HierarchyN cannot be used in TurboIntegrator processes. The presence of this function in a process will prevent the process from compiling.

Syntax

HierarchyN (DimName, index);

Argument	Description
DimName	A valid dimension name.
index	A value less than or equal to the number of hierarchies in the dimension. If this argument is less than 1, or greater than the number of hierarchies in the dimension, the function returns 0.

Argument

Description

DimName

A valid dimension name.

index

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

If this argument is less than 1, or greater than the number of hierarchies in the dimension, the function returns 0.

Example

This example returns 'CustomerTarget', which is the third hierarchy in the model dimension.

HierarchyN ('model', 3);