@ICHILDREN

English (Español a continuación)

This function allows to select the children (next level) of a given member, including the member himself (unlike @CHILDREN, which does not include the member himself).

Its structure is:

@ICHILDREN («Member»);

Let’s see an example:

Applying the function:

@ICHILDREN(“Vendors”);

We get the result:

Vendors
North Area
South Area
East Area
West Area

If we had applied the function @CHILDREN “Vendors” would not have been included in the result.

This function can be used within another function that requires a list of members:

@AVGRANGE(SKIPNONE,@ICHILDREN(“Vendors”));

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

Español

Esta función permite seleccionar los hijos (siguiente nivel) de un miembro determinado, incluyendo al propio miembro (a diferencia de @CHILDREN que no incluye al propio miembro).

Su estructura es:

@ICHILDREN(“Miembro”);

Veamos un ejemplo: