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
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.Basic
returns
Table 4-95 Output Grid from MDX Example
East | West | South | Central |
---|---|---|---|
24161 | 29861 | 13238 | 38262 |