Suppress Empty Cells in Relational Reporting

Sparse data may result in crosstabs showing empty cells. For example, a crosstab showings employees and products with a measure of revenue results in empty cells when the employee does not sell the product.

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 of your report.

IBM® Cognos® Workspace Advanced performs calculations before applying suppression. If you have multiple crosstabs or charts, you must select one to access suppression options.

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

Procedure

  1. From the Data menu, click Suppress suppress icon and click Suppression Options.
  2. Under Suppress, choose what sections to suppress.
  3. Under Suppress the following, choose which values to suppress.
Parent topic: Exploring Relational Data