ELPAR

ELPAR returns the parent of a member in a specified dimension

Syntax

ELPAR(server:dimension, element, index)

Argument	Description	Required/Optional
server:dimension	The name of the TM1® server and a dimension name.	Required
element	The name of a member within the dimension. This argument can also be the name of an alias for a dimension member.	Required
index	A positive value less than or equal to the total number of unique consolidated members (parents) that use the member argument as a child. Tip: You can use the ELPARN function to find out how many unique parents a member has.	Required

Example

The following examples use the SData TM1 server and a dimension called model with the following structure:

L Series 2WD
- L Series 4WD
- L Series
  - L Series Sedan
  - L Series Wagon
S Series 2WD
Total
- L Series
  - L Series Sedan
  - L Series Wagon
- S Series
- T Series

ELPAR("SData:model","L Series 4WD",1)

In this example, the function returns L Series 2WD, the parent of L Series 4WD.

ELPAR("SData:model","L Series",2)

In this example, the function returns Total. L Series is a child of two unique parents: L Series 2WD and Total. In the structure of the model dimension, Total appears second, so this is the member returned by the function.

ELPAR("SData:model","L Series Wagon",2)

In this example, the function returns a blank cell. L Series Wagon appears twice, but in both cases the parent is L Series. Since L Series Wagon does not have a second unique parent, the function returns a blank cell.