Returns TRUE if the current member is the specified member or an ancestor of the specified member. This function includes the specified member.
Syntax
@ISIANCEST (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:
@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.
See Also