@ISLEV

The @ISLEV calculation function for Essbase tests whether a member is in a specific level.

This function returns TRUE if the current member being calculated is in the specified level of the specified dimension.

Syntax

@ISLEV (dimName, levName | levNum)

Parameters

dimName: Name of a dimension.
levName | levNum: A level name or a non-negative integer value that defines the number of a level.

Example

In the Sample Basic database:

@ISLEV(Market,0)

Returns TRUE if the current member of Market is New York, California, Texas, or Illinois.

@ISLEV(Year,1)

Returns FALSE if the current member of Year is Jan, Feb, or Mar.