ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.
Where can the ELEMENTISCOMPONENT function be used?
Rules and TurboIntegrator
What is the ELEMENTISCOMPONENT function?
ELEMENTISCOMPONENT determines if the element is child of a consolidation or not. Function returns 1 if the element is child of consolidation.
What is the syntax for ELEMENTISCOMPONENT?
ElementIsComponent (dimension, hierarchy, element1, element2)
dimension = A dimension name.
Hierarchy = The name of the hierarchy.
Element1 = The name of the element within dimension.
Element2 = The name of the consolidated element within dimension.
A demonstration on how to use ELEMENTISCOMPONENT
Use ElementIsComponent function to determine if an element is child of a consolidation or not and apply it in the rule to populate the Comment 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