@ISIANCEST

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