TM1 Function for Rules, ELCOMP
ELCOMP returns the name of child of a consolidated element.
Where can the ELCOMP function be used?
Excel, Rules 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 child of a consolidated element.
What is the syntax for ELCOMP?
ELCOMP(dimension, element, position)
Dimension = A dimension name.
Element = The name of a consolidated element.
Position = Element position number in the consolidation.
A demonstration on how to use ELCOMP
Use ELCOMP function to retrieve the name of child from a Accessories consolidation and apply it in the rule to populate the Comment measure in the Product Scorecard cube.