ELISPAR
ELISPAR determines whether element1 is a parent of element2 in the specified dimension. The function returns TRUE if element1 is a parent of element2, otherwise the function returns FALSE.
This worksheet function is valid in worksheets only.
Syntax
ELISPAR(dimension, element1, element2)
Argument |
Description |
---|---|
dimension |
A valid dimension name. |
element1 |
The name of an element within the dimension. This argument can also be the name of an alias for a dimension element. |
element2 |
The name of an element within the dimension. This argument can also be the name of an alias for a dimension element. |
Example
ELISPAR("Region","Central Europe","Germany")
In the dimension Region, the consolidated element Central Europe is the parent of both Germany and France. Accordingly, the example returns TRUE
Note that this function returns TRUE only for immediate parents. In the above example, Europe is a parent of Central Europe. Further, Central Europe is a parent of Germany. However, because Europe is not an immediate parent of Germany, the following example returns FALSE:
ELISPAR("Region","Europe","Germany")