IsEmpty

Returns True if the value of an input numeric-value-expression evaluates to #MISSING, and returns FALSE otherwise.

Syntax

IsEmpty ( value_expression )

value_expression A set returning values to check for emptiness.

Note

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:

100 100 100 100 200 200 200 200 300 300 300 300 400 400 400 Diet Diet Diet Diet
East West South Central East West South Central East West South Central East West Central East West South Central
27740 28306 16280 33808 23672 34200 22008 29206 20241 35391 12558 33215 15745 35034 33451 7919 36423 18676 42660

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com