PARENT

Syntax

PARENT (Dimension, {Child Member})

Description

The PARENT function returns the member reference to the parent of the specified member.

Parameters

The PARENT function takes one required argument and one optional argument. The first argument is required. The second argument is optional.

Parameter	Description
Dimension	The dimension to use.
Child Member	If this optional argument is not supplied, use the current calculated member for this dimension. Note: If the child member is the root, this function returns 1.

Returns

The member reference to the parent of the specified member.

Example

PARENT (Region, [Region:West]) returns a reference to the parent of [Region:West], which is [Region:USA].