DE.PARENTNAME

Returns the parent of a specified element.

Syntax

DE.PARENTNAME(Database alias,Dimension,Element,Index)

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

The first three arguments may be strings or references to cells containing strings. If strings, they must be enclosed in quotes. The last argument must be a number or reference to a cell containing a number.

The 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.