DE.CHILDNAME

Returns the child of the specified consolidated element.

Syntax

DE.CHILDNAME(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 display.

Example

The Europe element of the REGION dimension has these children: Austria, Belgium, Czech Republic, Denmark, France, Germany, and so on. This example returns Germany:

DE.CHILDNAME('REGION', 'Europe', 6)

This example returns Belgium:

DE.CHILDNAME('REGION', 'Europe', 2)