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