ElPar Excel function for IBM Planning Analytics (TM1)
ElPar returns the parent of an element in a dimension.
In the video, ElPar will be used to return the parents for the element, Bike Racks.
Where can the ElPar function be used?
Excel, Rules and TurboIntegrator
Which TM1 Server version is the ElPar function available for?
Version 11 and 12
What is the syntax for ElPar?
ElPar(TM1ServerName:Dimension, Element, Index)
- TM1ServerName = Name of the TM1 Server
- Dimension = Name of the Dimension
- Element = Name of the element or alias
- Index = A positive value less than or equal to the total number of consolidated elements (parents) that use the element argument as a child
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