Hierarchy
If there is only one hierarchy included in the supplied dimension, Hierarchy returns the
name of the hierarchy. Otherwise, it returns an empty string. Hierarchy is valid in rules
only.
With the introduction of support for multiple hierarchies, it is necessary to identify which hierarchies are in context when multiple hierarchies are being used.
The Hierarchy function cannot be used in TurboIntegrator processes. The presence of this function in a process will prevent the process from compiling.
Syntax
Hierarchy (DimName);|
Argument |
Description |
|---|---|
|
DimName |
A valid dimension name. |
Example
This example returns 'Quarter', which is the only hierarchy in the Quarter dimension.
Hierarchy ('Quarter');