ELEMENTINDEX returns the index number of an element within a dimension.
Where can the ELEMENTINDEX function be used?
Rules and TurboIntegrator
What is the ELEMENTINDEX function?
ELEMENTINDEX returns the index number of an element within a dimension.
What is the syntax for ELEMENTINDEX?
ElementIndex(dimension, hierarchy, element)
Dimension = Dimension name.
Hierarchy = The name of the hierarchy.
Element = Element name.
A demonstration on how to use ELEMENTINDEX
Use ElementIndex function to retrieve the index number of an element of the Employee Hierarchies dimension and apply it in the rule to populate 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
