CHILD

Returns the nth child of a specified consolidated element.

Syntax

CHILD(Dimension, Element, Index)

Dimension is the name of the dimension which contains the element in question. Element is the element whose child you want to determine. Index is the number of the child to return.

Example

The Europe element of the REGION dimension has these children: Austria, Belgium, Czech Republic, Denmark, France, Germany etc., in that order. This example returns Germany:

CHILD('REGION', 'Europe', 6)

This example returns Belgium:

CHILD('REGION', 'Europe', 2)