ELISPAR determines if an element is parent of another element or not.
Available In
Excel, Rules and TurboIntegrator
Definition
ELISPAR determines if an element is parent of another element or not.
Syntax
ELISPAR(dimension, element1, element2)
Dimension = A dimension name.
Element1= The name of a consolidated element.
Element2 = The name of an element.
Video Demo
Use ELISPAR function to determine if the ‘All Products by Category’ element is parent or another elements or not and apply it in the rule to populate the Comment measure in the Product Scorecard 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