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.
To suppress missing values in rows, select a row and select Suppress, then Missing rows on the shortcut menu.
By default missing values are blank.
To suppress missing values in columns, select a column and select Suppress, then Missing columns on the shortcut menu.
To suppress zero values in rows, select a row and select Suppress, then Zero rows on the shortcut menu.
By default zero values are shown as 0 (zero).