The @ISIANCEST() function returns TRUE if the current member is the specified member or an ancestor of the specified member. This function includes the specified member.
@ISIANCEST(mbrName)
| mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
In the Sample Basic database:
@ISIANCEST(California)returns TRUE for Market, West, and California. California is the specified member, and West and Market are ancestors of California.
@ISIANCEST(Qtr1)returns FALSE for Jan, Feb, Mar, Qtr2. None of these members is the specified member (Qtr1) or an ancestor of Qtr1.
@ISANCEST, which excludes the specified member.
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.
