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 )

Parameters

value_expression

A set returning values to check for emptiness.

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