@ISANCEST

The @ISANCEST calculation function for Essbase tells whether a member is an ancestor of another member.

This function 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