Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

IsAncestor (MDX)

Updated: 17 July 2006

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


IsAncestor(Member_Expression1, Member_Expression2) 

Member_Expression1

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

Member_Expression2

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

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

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.

Community Additions

ADD
Show:
© 2014 Microsoft