Export (0) Print
Expand All
Expand Minimize

IsAncestor (MDX)

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft