ELEMENTNAME returns the element of a dimension based on the index argument.
Where can this function be used?
Rules and TurboIntegrator
What is the function’s definition?
ELEMENTNAME returns the element of a dimension based on the index argument.
What is the function’s syntax?
ElementName(dimension, hierarchy, index)
Dimension = Dimension name.
Hierarchy = The name of the hierarchy.
Index = A positive value.
A demonstration on how to use this function
Use ElementName function to retrieve the name 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