IBM Support

Suppression does not suppress all expected rows

Technote (troubleshooting)


Problem(Abstract)

The user configured 'Suppress Rows Only' in a report containing a crosstab. Zero values, divide by zero, missing values and overflow values are configured for suppression.

Symptom

The report result still contains some rows which contain a zero in each column.


Cause

There is a hidden column with fact cells in the crosstab. The values of this column are not zero for the expected rows.

Resolving the problem

To get a consistent report output, either do not hide this column or remove this column from the crosstab.

Document information

More support for: Cognos Business Intelligence
Report Studio

Software version: 8.4.1, 10.1, 10.1.1, 10.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1617342

Modified date: 12 September 2014