## IsEmpty

The MDX IsEmpty function for Essbase returns TRUE if the value of an input numeric-value-expression evaluates to #MISSING, and returns FALSE otherwise.

Syntax

`IsEmpty ( value_expression )`

Notes

Zero is not equivalent to #MISSING. `IsEmpty(0)`

returns TRUE.

Example

The following example finds all Product, Market combinations for which Sales data exists.

```
WITH SET [NewSet]
AS 'CrossJoin([Product].Children, [Market].Children)'
SELECT
Filter([NewSet], NOT IsEmpty([NewSet].CurrentTuple))
ON COLUMNS
FROM Sample.Basic
WHERE
{[Sales]}
```

This query returns the following grid:

Table 4-92 Output Grid from MDX Example

100 | ... | 400 | Diet | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|

East | West | South | Central | ... | East | West | Central | East | West | South | Central |

27740 | 28306 | 16280 | 33808 | ... | 15745 | 35034 | 33451 | 7919 | 36423 | 18676 | 42660 |