IsAncestor

Analysis Services

Analysis Services

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