IsLeaf

Returns TRUE if the member is a level-0 member.

Syntax

IsLeaf ( member )

member A member specification.

Notes

IsLeaf(member) is the same as IsLevel(member, 0).

Example

IsLeaf([Market].CurrentMember) 
returns TRUE if the current member of the Market dimension is at level 0.

Therefore, the following query

SELECT
 Filter([Market].Members, IsLeaf([Market].CurrentMember))
ON COLUMNS
FROM Sample.Basic

returns

New York Massachusetts Florida Connecticut New Hampshire California Oregon Washington Utah Nevada Texas Oklahoma Louisiana New Mexico Illinois Ohio Wisconsin Missouri Iowa Colorado
8202 6712 5029 3093 1125 12964 5062 4641 3155 4039 6425 3491 2992 330 12577 4384 3547 1466 9061 7227

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