ELEMENTCOMPONENT returns the name of child of a consolidated element.
Where can the ELEMENTCOMPONENT function be used?
Rules and TurboIntegrator
What is the ELEMENTCOMPONENT function?
ELEMENTCOMPONENT returns the name of child of a consolidated element.
What is the syntax for ELEMENTCOMPONENT?
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.
A demonstration on how to use ELEMENTCOMPONENT
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