Excel Functions
TM1 Function – ELPAR
Available In
Excel
Definition
ELPAR returns the parent of an element in a dimension.
Syntax
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
Example
From the Product Type dimension, get the parents for Bike Racks.
The parents are Accessories and All Products.
In Excel:
ELPAR(“AdventureWorks:Product Type”, “Bike Racks”, 1) returns the first parent, Accessories.
ELPAR(“AdventureWorks:Product Type”, “Bike Racks”, 1) returns the second parent, All Products.