ELEMENTCOMPONENT returns the name of child of a consolidated element.
Available In
Rules and TurboIntegrator
Definition
ELEMENTCOMPONENT returns the name of child of a consolidated element.
Syntax
ElementComponent(dimension, hierarchy, element, position)
Dimension = A dimension name.
Hierarchy = The name of the hierarchy.
Element = The name of a consolidated element within dimension.
Position = A positive value.
Video Demo
Use ElementComponent function to retrieve the name of a child from a consolidated element of the Employee Hierarchies dimension and apply it in the rule to populate the TestS measure in the Employee Salaries 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