@IALLANCESTORS

English (Español a continuación)

This function gets all the ancestors of a given member, including those it would have if the member were also in the outline as a shared member. Include the member himself in this result.

Its difference with the @ALLANCESTORS function is that the latter does NOT include the member itself in the result.

The structure of the function is:

@IALLANCESTORS (Member);

Let’s see an example: Starting from the following outline:

The function:

@IALLANCESTORS (“LERIDA”);

The result is:

LERIDA
CATALONIA
SPAIN
EUROPE

Sorted from closest to furthest.

This function can be used as a parameter to another function that requires a list of members:

For example:

@AVGRANGE(SKIPNONE,”Sales”,@IALLANCESTORS (“LERIDA”));

Any question, please send an email to: essbaseeasy@gmail.com

Español

Esta función obtiene todos los ascendientes de un miembro determinado, incluyendo aquellos que tuviere si el miembro figurara también en el outline como miembro compartido. Incluye en este resultado al propio miembro.