IsAncestor (MDX)

Returns whether a specified member is an ancestor of another specified member.

Syntax

IsAncestor(Member_Expression1, Member_Expression2) 

Arguments

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

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

Remarks

The IsAncestor function returns true if the first member specified is an ancestor of the second member specified. Otherwise, the function returns false.

Example

The following example returns true if [Time].[Fiscal].CurrentMember is an ancestor of [Time].[Fiscal].[[January]:

IsAncestor([Time].[Fiscal].CurrentMember, [Time].[Fiscal].[January])

See Also

Reference

Ancestor (MDX)
MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
17 July 2006	Changed content: Updated syntax and arguments to improve clarity. Added updated examples.