TM1 Function for Excel, ELCOMPN

ELCOMPN returns number of components under an element.

Where can the ELCOMPN function be used?

Excel, Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the ELCOMPN function?

ELCOMPN returns number of components under an element.

What is the syntax for ELCOMPN?

ELCOMPN(TM1ServerName:Dimension, Element)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = Name of the element or alias

A demonstration on how to use ELCOMPN

From the Product Type dimension, return the number of components under Accessories.