@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