Returns TRUE if the member is a level-0 member.
Syntax
IsLeaf ( member )
Parameter | Description |
---|---|
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 | ... | Missouri | Iowa | Colorado |
---|---|---|---|---|---|---|
8202 | 6712 | 5029 | ... | 1466 | 9061 | 7227 |