Returns TRUE if the member is a level-0 member.
IsLeaf ( member )
member | A member specification. |
IsLeaf(member)
is the same as IsLevel(member, 0)
.
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 |