ELWEIGHT returns the element’s weight to a consolidated element in a dimension.
Where can the ELWEIGHT function be used?
Excel, Rules and TurboIntegrator
What is the ELWEIGHT function?
ELWEIGHT returns the element’s weight to a consolidated element in a dimension.
What is the syntax for ELWEIGHT?
ELWEIGHT(TM1ServerName:Dimension, ParentElement, ChildElement)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
ParentElement = Parent element of child element to be queried
ChildElement = Element to be queried of its weighting
A demonstration on how to use ELWEIGHT
In the Account dimension for the Net Income consolidation, return the weight for every child.
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