IsLeaf
The MDX IsLeaf function for Essbase returns TRUE if the member is a level-0 member.
Syntax
IsLeaf ( member )Parameters
- member
-
A member specification.
Notes
IsLeaf(member) is the same as IsLevel(member, 0).
Example
The following expression:
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.Basicreturns the following output (truncated):
Table 4-94 Output Grid from MDX Example
| New York | Massachusetts | Florida | ... | Missouri | Iowa | Colorado |
|---|---|---|---|---|---|---|
| 8202 | 6712 | 5029 | ... | 1466 | 9061 | 7227 |