ElParN Excel function for IBM Planning Analytics (TM1) – Excel

ElParN returns the number of parents of an element. In the video, ElParN will be demoed in Excel to return the number of parents ‘Bikes’ belongs to, from the Product Type dimension. Please note that the same logic can be used in TurboIntegrator and Excel. For the video demo, as a Rule, 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(TM1Server:dimension, element)

TM1Server = Name of the TM1 Server Database
Dimension = A dimension name.
Element = The name of an element.

Relevant Functions

ElComp = Returns the name of a child element from a consolidated element based on the position
ElCompN = Returns the number of components under an element
ElIsComp = Determine whether an element is a component of a parent element in a dimension
ElIsPar = Determine whether an element is a parent of a child in a dimension
ElLev = Returns the level of an element within a dimension
ElPar = Determine whether an element is a parent of a child in a dimension
ElParN = Returns the number of parents for an element
ElSLen = Returns the number of characters in the element in a dimension
ElWeight = returns the element’s weight to a consolidated element in a dimension