Apply Zero Suppression

You can use zero suppression to ignore categories whose values fall into a low range.

For example, sales channels that are not active contributors to the bottom line are better left out of the report. You can also ignore categories that either do not apply to the report or that return zero values.

The default zero suppression settings remove rows or columns containing all zeros, missing values, overflow values, or the results of dividing by zero. You can do this for rows, columns, or both. Zero suppression only applies to the first measure.

When you apply zero suppression to a chart that supports multiple measures, the suppression is only applied to the first measure. You cannot apply suppression to a second measure, such as the line of a correlation chart, or to conditions when both measures are zero.

The Explain window includes information about your selected zero suppression options, and any IBM® Cognos® PowerPlay® URLs created by the Prepare Bookmark command retain your changed settings, provided zero suppression was enabled for the crosstab.

Enabling zero suppression on a large reports may have a negative impact on performance.

Before you begin

The PowerPlay administrator can enable or disable zero suppression options for specific cubes or reports. If any of the options described below are not available, contact your administrator.

Procedure

  1. Click the zero suppression options button zero suppression icon.
  2. Click Zero Suppression to suppress zeros in the entire report, or click either Rows Only or Columns Only.
  3. To change the default zero suppression settings, click the zero suppression options button and click Options.
  4. Change the suppression settings and click OK.

    To remove the suppression, click the zero suppression button again.

    If you want to retain your changed settings after you return from a drill-through report or cube, remember to use Return to Source. Any other navigation method will cause your changes to be lost, and your report will revert to the default zero suppression settings.