@ISANCEST

Function

The @ISANCEST() function returns TRUE if the current member is an ancestor of the specified member. This function excludes the specified member.

Syntax

@ISANCEST(mbrName)

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)   TRUE    for Market, West
@ISANCEST(West)         FALSE   for California, West, East

See Also

@ISIANCEST, which includes the specified member, returning TRUE if the current member is the specified member or the parent of the specified member.

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.