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’.