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

Where can the ElParN function be used?

Which TM1 Server version is the ElParN function available for?

What is the syntax for ElParN?

• 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