Excel Functions

TM1 Function – ELISPAR

Available In

Excel

Definition

ELISPAR determines whether an element is a parent of a child in a dimension.

Syntax

ELISPAR(TM1ServerName:Dimension, ParentElement, ChildElement)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
ParentElement = Name of the parent element or alias
ChildElement = Name of the child element or alias

Example

From the Product Type dimension, find out if Bikes is the parent of Mountain Bikes.

The result should return TRUE.

In Excel:

ELISPAR(“AdventureWorks:Product Type”, “Bikes”, “Mountain Bikes”) returns TRUE

Video Demo