Returns TRUE if the member is in a specified level.
IsLevel ( member , index )
member | A member specification. |
index | A level number. |
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 |