IsLevel
The MDX IsLevel function for Essbase returns TRUE if the member is in a specified level.
Syntax
IsLevel ( member, index )Parameters
- member
-
A member specification.
- index
-
A level number.
Example
The following expression:
IsLevel([Market].CurrentMember, 1) returns TRUE if the current member of the Market dimension is at level 1.
Therefore, the following query:
SELECT
Filter([Market].Members, IsLevel([Market].CurrentMember, 1))
ON COLUMNS
FROM Sample.Basicreturns the following output:
Table 4-95 Output Grid from MDX Example
| East | West | South | Central |
|---|---|---|---|
| 24161 | 29861 | 13238 | 38262 |