## TM1 Function for Excel, ELPARN

### ELPARN returns the number of parent elements for an element.

**Where can the ELPARN****function be used?**Excel, Rules and TurboIntegrator

**What is the ELPARN****function?****ELPARN** returns the number of parent elements for an element.

**What is the syntax for ELPARN?**ELPARN(TM1ServerName:Dimension, Element)

TM1ServerName = Name of the TM1 Server

Dimension = Name of the Dimension

Element = Name of the element or alias

**ELPARN****A demonstration on how to use**From the **Product Type** dimension, get the number of parents for **Bikes** is a component of.