Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

IsAncestor

SQL Server 2000

IsAncestor

Returns TRUE if a specified member is an ancestor of another specified member, FALSE otherwise.

Syntax

IsAncestor(«Member1»,«Member2»)

Remarks

This function returns TRUE if the member indicated in «Member 1» is an ancestor of the member specified in «Member 2».

Example

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

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

See Also

Ancestor

Show:
© 2015 Microsoft