Skip to main content

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

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])