ELCOMP returns the name of child of a consolidated element.
Available In
Excel, Rules and TurboIntegrator
Definition
ELCOMP returns the name of child of a consolidated element.
Syntax
ELCOMP(dimension, element, position)
Dimension = A dimension name.
Element = The name of a consolidated element.
Position = Element position number in the consolidation.
Video Demo
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 demo