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