Excel Functions

TM1 Function – ELCOMPN

Available In

Excel

Definition

ELCOMPN returns number of children in a consolidation.

Syntax

ELCOMPN(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, return the number of components under Accessories, which has 12 children.

In Excel:

ELCOMPN(“AdventureWorks:Product Type”, “Accessories”) returns 12.

Video Demo