ELCOMP returns the name of child of a consolidated element.
Where can the ELCOMP function be used?
Excel, Rules and TurboIntegrator
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.
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