TM1 Function for Excel, ELPAR
ELPAR returns the parent of an element in a dimension.
Where can the ELPAR function be used?
Excel, Rules and TurboIntegrator
What is the ELPAR function?
ELPAR returns the parent of an element in a dimension.
What is the syntax for ELPAR?
ELPAR(TM1ServerName:Dimension, Element, Index)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = Name of the element or alias
Index = A positive value less than or equal to the total number of consolidated elements (parents) that use the element argument as a child
A demonstration on how to use ELPAR
From the Product Type dimension, get the parents for Bike Racks.