ELPARN

ELPARN returns the number of unique parents of a member in a specified dimension.

Syntax

ELPARN(server:dimension, element)

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

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
ELPARN("SData:model","L Series")
In this example, the function returns 2. In the model dimension, L Series has two unique parents: L Series 2WD and Total. 
ELPARN("SData:model","L Series Wagon")
In this example, the function returns 1. In the model dimension, L Series Wagon has one unique parent, L Series.