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.

Video Demo