IsAncestor (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 [Date].[Fiscal].CurrentMember is an ancestor of January 2003:

WITH MEMBER MEASURES.ISANCESTORDEMO AS

IsAncestor([Date].[Fiscal].CurrentMember, [Date].[Fiscal].[Month].&[2003]&[1])

SELECT MEASURES.ISANCESTORDEMO ON 0,

[Date].[Fiscal].MEMBERS ON 1

FROM [Adventure Works]

See Also

Ancestor (MDX)
MDX Function Reference (MDX)