Excel Functions

TM1 Function – ELCOMP

Available In

Excel

Definition

ELCOMP returns the name of a child element from a consolidated element based on the position.

Syntax

ELCOMP(TM1ServerName:Dimension, Element, Position)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = Name of the element or alias
Position = A value showing the position of the child element under the consolidated element

Example

From the Product Type dimension, return the first two children from the Accessories consolidation which is Bike Racks and Bike Stands.

In Excel:

ELCOMP(“AdventureWorks:Product Type”, “Accessories”, 1) returns ‘Bike Racks’.

ELCOMP(“AdventureWorks:Product Type”, “Accessories”, 2) returns ‘Bike Stands’.

Video Demo