ElementIsParent
ElementIsParent determines whether element1 is a parent of element2 in the specified dimension. The function returns 1 if element1 is a parent of element2, otherwise the function returns 0.
This function is valid in both rules and TurboIntegrator processes.
Syntax
ElementIsParent(dimension, hierarchy, element1, element2)|
Argument |
Description |
|---|---|
|
dimension |
A valid dimension name. |
|
hierarchy |
The name of the hierarchy within the dimension. |
|
element1 |
The name of an element within the dimension. |
|
element2 |
The name of an element within the dimension. |
Example
In the dimension Region, the consolidated element Central Europe is the parent of both Germany and France. Accordingly, the example returns 1.
Note: this function returns 1 only for immediate parents. In the previous example,
Europe is a parent of Central Europe. Further, Central Europe is a parent of Germany.
ElementIsParent('Region', 'Countries', 'Central Europe', 'Germany')However, because Europe is not an immediate parent of Germany, the following example returns 0:
ElementIsParent('Region', 'Countries', 'Europe', 'Germany')