TM1 Function for Excel, ELCOMP
ELCOMP returns the name of a child element from a consolidated element based on the position.
Where can the ELCOMP function be used?
Excel, Rule and TurboIntegrator
Which TM1 Server version is this function available for?
Version 11 and 12
What is the ELCOMP function?
ELCOMP returns the name of a child element from a consolidated element based on the position.
What is the syntax for ELCOMP?
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
A demonstration on how to use ELCOMP
From the Product Type dimension, return the first three children from the Accessories consolidation.