Skip to main content
Version: I2023.2.0

Parent

Syntax

Member_Expression.Parent

Input Parameters

Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.

Return Value

The Parent function returns the parent member of the specified member. In the case of the (All) member, this function returns a NULL value that is detectable with ISEMPTY().

note

Note: Rather than chaining together .parent calls (e.g. .currentMember.parent.parent) it is strongly recommended that you use the ANCESTOR function to avoid performance problems.

Example

Return the Parent Product's Sales Amount

([Product].[Product Categories].CurrentMember.Parent, [Measures].[Internet Sales Amount Local])