ELPAR function#

ELPAR returns the name of the parent of an element at a given parent index - the roll-up navigation function.

Signature#

=ELPAR("Server:Dimension", element, index)

#	Argument	Type	Required	Permitted values and notes
1	`Server:Dimension`	String	Yes	`"server:dimension"`.
2	`element`	String	Yes	Element name. A numeric value warns but is accepted.
3	`index`	Integer	Yes	The parent to return, 1-based. Must be a whole number of at least 1.

ELPAR takes exactly three arguments. The default result is an empty string.

For the shared error model and the Calc Mode effect, see how Reportworq handles errors.

Situation	Result
More than three arguments	Hard error
Fewer than three arguments	Warning, blank
`index` is not numeric or cannot be parsed	Hard error
`index` is less than 1	Warning, blank
The element is a string element	Warning, blank - a string element has no parents
`index` is greater than the number of parents	Warning, blank
Dimension or element not found	Warning, blank

=ELPAR("PlanTM1:Region", "Northeast", 1)

IBM Planning Analytics functions - the function index and the shared error model.
ELPARN function - the number of parents of an element.
ELCOMP function - a child of a consolidation.

Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.