ISANCESTOR
Description:
This function is used to return whether a specified member is an ancestor of another specified member.
Syntax:
IsAncestor(Member_Expression1, Member_Expression2)
Return Type:
LOGICAL
Parameters:
Parameter | Description |
|---|---|
Member_Expression1 | It is a valid MDX expression that returns a member. |
Member_Expression2 | It is a valid MDX expression that returns a member. |
Example:
with member MEASURES.ISANCESTORDEMO as
IsAncestor([Delivery Date].[Delivery Calendar].CurrentMember,[Delivery Date].[Delivery Calendar].[Month].&[2005]&[1]&[1]&[February] )
SELECT MEASURES.ISANCESTORDEMO ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [AdventureWorksMF]