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.