ELEMENTISANCESTOR determines if the element is an ancestor of another element or not.
Where can the ELEMENTISANCESTOR function be used?
Rules and TurboIntegrator
What is the ELEMENTISANCESTOR function?
ELEMENTISANCESTOR determines if the element is an ancestor of another element or not. Function returns 1 if the element is ancestor of another element.
What is the syntax for ELEMENTISANCESTOR?
ElementIsAncestor(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 ELEMENTISANCESTOR
Use ElementIsAncestor function to determine if the consolidation element is an ancestor of another element 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