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].[Is Bikes Ancestor] AS
IsAncestor([Product].[Product Categories].[Bikes], [Product].[Product Categories].[Mountain Bikes])
SELECT
[Measures].[Is Bikes Ancestor] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]