ELISCOMP

ELISCOMP determines whether element1 is an immediate child of element2 in the specified dimension.

The function returns TRUE if element1 is an immediate child of element2, otherwise the function returns FALSE.

Syntax

ELISCOMP(server:dimension, element1, element2)

Argument

Description

 Required/Optional

server:dimension

The name of the TM1® server and a dimension name.

 Required

element1

The name of a member within the dimension. This argument can also be the name of an alias for a dimension member.

 Required

element2

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
ELISCOMP("GO_New_Stores:Products","Tents","Golf Equipment")
In this example, the function returns FALSE because Tents is not a child of the Golf Equipment member in the Products dimension. 
ELISCOMP("GO_New_Stores:Products","Tents","Camping Equipment")

In this example, the function returns TRUE because Tents is a child of the Camping Equipment member.

Note that the ELISCOMP function returns TRUE only for immediate children. In the above example, Tents is a child of Camping Equipment. Further, Camping Equipment is a child of Total Products. However, because the function returns TRUE only for immediate children, the following example returns FALSE:

ELISCOMP("GO_New_Stores:Products","Tents","Total Products")