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.Basic

returns the following output:

Table 4-95 Output Grid from MDX Example

East	West	South	Central
24161	29861	13238	38262

See Also

Level

IsGeneration