Excel Functions

TM1 Function – ELISCOMP

Available In

Excel

Definition

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

Syntax

ELISCOMP(TM1ServerName:Dimension, ComponentElement, ParentElement)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
ComponentElement = Name of the component element or alias
ParentElement = Name of the parent element or alias

Example

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

The query should return true.

In Excel:

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

Video Demo