ELEMENTWEIGHT returns the weight of a child element in a consolidation element.
Where can the ELEMENTWEIGHT function be used?
Rules and TurboIntegrator
What is the ELEMENTWEIGHT function?
ELEMENTWEIGHT returns the weight of a child element in a consolidation element.
What is the syntax for ELEMENTWEIGHT?
ELEMENTWEIGHT (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 ELEMENTWEIGHT
Use ELEMENTWEIGHT function to retrieve weight of a child element of a consolidation 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