TM1 Function for Excel, ELPARN
ELPARN returns the number of parent elements for an element.
Where can the ELPARN function be used?
Excel, Rules and TurboIntegrator
What is the ELPARN function?
ELPARN returns the number of parent elements for an element.
What is the syntax for ELPARN?
ELPARN(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 ELPARN
From the Product Type dimension, get the number of parents for Bikes is a component of.