DE.PARENTNAME

Returns the parent of the specified element.

Syntax

DE.PARENTNAME(Dimension, Element, Index)

Dimension is the name of the dimension. Element is the element whose parent you want display. Index is the number of the parent.

The first three arguments can be strings or references to cells containing strings. Strings must be enclosed in quotes. The last argument must be a number or reference to a cell containing a number.

Index can be a number other than 1 if the element occurs several times in a hierarchy under different parents. For example, in a hierarchy of regions, a country could be a child of both a European Union element and a Central Europe element.

Example

The Bayern element in the REGION dimension rolls up into the parent, Germany. This example returns Germany:

DE.PARENTNAME('REGION', 'Bayern', 1)