Excel Functions

TM1 Function – ELCOMP

Available In



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


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


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