@ISIANCEST

The @ISIANCEST calculation function for Essbase returns TRUE if the current member is an ancestor (or a match) of the specified member.

Syntax

@ISIANCEST (mbrName)

Parameters

mbrName: Any valid single member name, or a function that returns a single member.

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.