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.