ELCOMP

ELCOMP returns the name of a child of a consolidated member in a specified dimension.

Syntax

ELCOMP(server:dimension, element, index)

Argument	Description	Required/Optional
server:dimension	The name of the TM1® server and a dimension name.	Required
element	The name of a consolidated member within the dimension. This argument can also be the name of an alias for a dimension member. If the member is not a consolidated member, the function returns 0.	Required
index	A positive value less than or equal to the total number of children in the specified member. If you enter a value greater than the number of children in the member or if you enter 0, the function returns a blank cell.	Required

Argument

Description

Required/Optional

server:dimension

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

Required

element

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

If the member is not a consolidated member, the function returns 0.

Required

index

A positive value less than or equal to the total number of children in the specified member.

If you enter a value greater than the number of children in the member or if you enter 0, the function returns a blank cell.

Required

Example

In this example, the TM1 server name is GO_New_Stores. The function returns the second child member under Europe. If Europe is a consolidated member with the children Central Europe, Northern Europe, and Southern Europe, the function returns Northern Europe.

Europe
- Central Europe
- Northern Europe
- Southern Europe

ELCOMP("GO_New_Stores:Country and Region","Europe",2)