Excel Functions

TM1 Function – ELPARN

Available In

Excel

Definition

ELPARN returns the number of parent elements for an element.

Syntax

ELPARN(TM1ServerName:Dimension, Element)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = Name of the element or alias

Example

From the Product Type dimension, get the number of parents for Bikes is a component of.

In the Product Type dimension, Bikes has one parent.

In Excel:

ELPARN(“AdventureWorks:Product Type”, “Bikes”) returns 1.

Video Demo