@ISANCEST

The @ISANCEST calculation function for Essbase returns TRUE if the current member is an ancestor of the specified member. This function excludes the specified member.

Syntax

@ISANCEST (mbrName)

Parameters

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

Example

In the Sample Basic database:

@ISANCEST(California)

Returns TRUE for Market, West

@ISANCEST(West)

Returns FALSE for California, West, East