Suppressing missing and zero values in rows and columns prevents irrelevant information from being returned, reduces network traffic, and increases query speed. Query options box enables you to customize how CubeQuery handles missing and zero values, including the text label displayed for these values by default. You can suppress the values on the shortcut menu.
To suppress missing values in rows, right-click a row and select Suppress, then Missing rows.
By default, missing values are blank.
To suppress missing values in columns, right-click a column and select Suppress, then Missing columns.
By default zero values are shown as 0 (zero).