Suppress Empty Cells in Dimensional Reporting

Sparse data may result in crosstabs showing empty cells. For example, a crosstab that matches employees with products results in many rows of empty values for the revenue measure if the employee does not sell those products.

You can suppress rows, columns, or rows and columns based on divide by zero, missing, and overflow values. Suppressing rows or columns without data gives you a more concise view or your report.

Calculations are performed before suppression is applied. If you have multiple crosstabs or charts, you must select one in order to access suppression options.

Access to the suppression feature depends on the settings in your modeling component, IBM® Cognos Transformer, IBM Cognos® Framework Manager, and IBM Cognos Administration.

You can also use filters to suppress null cells in your reports. Using filters ensures that calculations take suppression into account. You may also obtain better report performance because the filtering is done at the data source.

Procedure

From the Data menu, click Suppress and click Suppression Options.
Under Suppress, choose what sections to suppress.
Under Suppress the following, choose which values to suppress.