@ISIANCEST

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

This function returns TRUE if the current member being calculated is the specified member or an ancestor of the specified member. This function includes 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.