View - Suppress Blank MDX Data

This command gives you control over whether to include empty categories in the result set of an MDX query. If for example you request total sales by salesman and product, the OLAP Cube will contain data only for those combinations of those two dimensions for which sales records exist in the underlying database. By default, MDX query syntax will return rows for all possible combinations (the Cartesian product of the two dimensions). This command inserts MDX syntax to suppress empty combinations.