Essbase @ISLEV

Returns TRUE if the current member of the specified dimension is in
the specified level.

Syntax

@ISLEV (dimName, levName | levNum)
Parameter Description
dimName Name of a dimension.
levName | levNum A level name or an integer value that defines the number of a level.
A value of 0 or a negative integer defines a level number.

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.

See Also

  • @ISSAMELEV
  • @ISGEN