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