DE.PARENTNAME

Returns the parent of the specified element.

Tip: This function is also available by its alias PARENT. See PARENT.

Syntax

DE.PARENTNAME(Dimension, Element, Index)

Parameters

Dimension is the name of the dimension.

Element is the element name whose parent you want to get. Index is the number of the parent.

Note: The Dimension and Element arguments can be strings or operations that result in a string. The hardcoded strings must be enclosed in single or double straight quotes.

The Index argument must be a number or an operation that results in a number. It 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)