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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book