@ISANCEST

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)
Returns TRUE for Market, West
@ISANCEST(West)
Returns 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.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com