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.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |