Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

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