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
Which TM1 Server version is this function available for?
Version 11 and 12
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.