ELEMENTISPARENT determines if an element is parent of another element or not.
Where can the ELEMENTISPARENT function be used?
Rules and TurboIntegrator
What is the ELEMENTISPARENT function?
ELEMENTISPARENT determines if an element is parent of another element or not.
What is the syntax for ELEMENTISPARENT?
ElementIsParent(dimension, hierarchy, element1, element2)
Dimension = A dimension name.
Hierarchy = The name of the hierarchy.
Element1= The name of a consolidated element.
Element2 = The name of an element.
A demonstration on how to use ELEMENTISPARENT
Use ElementIsParent function to determine if an element is parent or another elements 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