ELPAR
ELPAR returns the parent of an element in a specified dimension.
This function is valid in both rules and TurboIntegrator processes.
Syntax
ELPAR(dimension, element, index)
Argument |
Description |
---|---|
dimension |
A valid dimension name. |
element |
The name of an element within the dimension. |
index |
A positive value less than or equal to the total number of consolidated elements (parents) that use the element argument as a child. |
Example
In the dimension Model, the element Wagon 4WD is a child of both Total Wagons and Total 4WD. Therefore, both Total Wagons and Total 4WD are parents of Wagon 4WD. In the structure of the Model dimension, Total Wagons is defined first, Total 4WD is defined second.
ELPAR('Model','Wagon 4WD',2)
The example returns Total 4WD, as this is the second instance of a parent to Wagon 4WD within the Model dimension.