TM1 Function for Excel, ELWEIGHT
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.