PARENT

Returns the parent of the specified element.

Syntax

PARENT(Dimension, Element, Index)

Example

For this example, use the SALES cube.

If the AS600/175 element in the Product dimension rolls up into 3 different parents: AS600 Aquachrono, T (118 mph 190 km/h) and 175, this example returns T (118 mph 190 km/h):

PARENT('Product', 'AS600/175', 2)