IsLevel

Returns TRUE if the member is in a specified level.

Syntax

IsLevel ( member , index )

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

East West South Central
24161 29861 13238 38262

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com