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