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.