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. Zero is not equivalent to #MISSING. IsEmpty(0) returns TRUE.

Syntax

IsEmpty ( value_expression )

Parameters

value_expression: A set returning values to check for emptiness.

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]}

The above 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