ELISPAR
ELISPAR determines whether member1 is an immediate parent of member2 in the specified dimension.
The function returns TRUE if member1 is an immediate parent of member2, otherwise the function returns FALSE.
Syntax
ELISPAR(server:dimension, member1, member2)|
Argument |
Description |
Required/Optional |
|---|---|---|
|
server:dimension |
The name of the TM1® server and a dimension name. |
Required |
|
member1 |
The name of a member within the dimension. This argument can also be the name of an alias for a dimension member. |
Required |
|
member2 |
The name of a member within the dimension. This argument can also be the name of an alias for a dimension member. |
Required |
Example
The following examples use the GO_New_Stores TM1 server and a dimension called Products with the following structure:
- Total Products
- Camping Equipment
- Tents
- Lanterns
- Golfing Equipment
- Putters
- Golf Accessories
- Mountaineering Equipment
- Rope
- Camping Equipment
ELISPAR("GO_New_Stores:Products","Mountaineering Equipment", "Tents")In this example, the function returns FALSE because Mountaineering Equipment is not a parent member of Tents in the Products dimension.
ELISPAR("GO_New_Stores:Products","Camping Equipment","Tents")In this example, the function returns TRUE because Camping Equipment is a parent member of Tents in the Products dimension.
Note that the ELISPAR function returns TRUE only for immediate parents. In the previous example, Total Products is a parent of Camping Equipment. Further, Camping Equipment is a parent of Tents. However, because Total Products is not an immediate parent of Tents, the following example returns FALSE:
ELISPAR("GO_New_Stores:Products","Total Products","Tents")