@ISANCEST

Returns TRUE if the current member is an ancestor of the specified member. This function excludes the specified member.

Syntax

@ISANCEST (mbrName)
Parameter Description

mbrName

Any valid single member name or member combination, or a function that returns a single member or member combination.

Example

In the Sample Basic database:

@ISANCEST(California)

Returns TRUE for Market, West

@ISANCEST(West)

Returns FALSE for California, West, East

See Also