Ancestor

Syntax

Ancestor(Member_Expression, Level_Expression)

Ancestor(Member_Expression, Distance)

Input Parameters

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

Level_Expression
A valid Multidimensional Expressions (MDX) expression that returns a level.

Distance
A valid numeric expression that specifies the distance from the specified member.

Return Value

A function that returns the ancestor of a specified member at a specified level or at a specified distance from the member.

Examples

Return the Sales Amount for the Product's currentMember's Category

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

Return the Sales Amount for the Product's currentMember's first degree ancestor (aka "Parent")

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