ELPARN function for IBM Planning Analytics (TM1)
ELPARN returns the number of parents of an element. In the video, ELPARN will be demoed in a Rule, but you can also use the same logic in TurboIntegrator and Excel. For the video demo in Excel, head here.
ELPAR could be used in conjunction with ELPARN to return the parent’s element name.
Where can the ELPARN function be used?
Rules, TurboIntegrator and Excel
Which TM1 Server version is the ELPARN function available for?
Version 11 and 12
What is the syntax for ELPARN?
ELPARN(dimension, element)
- Dimension = A dimension name.
- Element = The name of an element.
Relevant Functions
- ELPAR: Returns the parent of an element in a dimension