The @ISLEV() function returns TRUE if the current member of the specified dimension is in the specified level.
@ISLEV(dimName, levName | levNum)
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. |
In the Sample Basic database:
@ISLEV(Market,0) TRUE if the current member of Market is New York, California, Texas, or Illinois @ISLEV(Year,1) FALSE if the current member of Year is Jan, Feb, or Mar
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.