Working with empty cells: NON EMPTY keyword

If there is no data at the intersection of two or more dimensions, then any MDX query that references those intersections returns a number of empty values. For example, if a product is launched part way through a year, an MDX select query to identify sales of that product over the course of the whole year will reference a number of empty cells.

You can exclude empty cells from your queries. One way to do this is to use the NON EMPTY keyword to exclude empty tuples. The NON EMPTY keyword excludes empty tuples, not empty cells. A tuple that contains empty cells is not necessarily an empty tuple. Only empty tuples are excluded by the NON EMPTY keyword.

Example

This example uses the NON EMPTY keyword:

SELECT
   {[Measures].Members} ON COLUMNS,
   NON EMPTY {{[Years].Members} * {[Months].[Level 3].Members}} ON ROWS
FROM TotSales
WHERE ([Products].[ProView SVGA 17+])