IBM Support

IBM Cognos ICM - Adding partition with null values

Technote (FAQ)


When having multiple sources is a calculation, is there a way to display rows with null in the partition column?


Rows having null in the partition column are not displayed.


The default behavior is that when a calculated result partition is empty, it will be excluded.

This behavior can be changed, in order for the rows having null in the partition column to be displayed as well: there is the option to check 'Include Empty Partitions' on the partitions screen. This will add an additional prompt and will indicate that zeros should be added to any empty results. IBM is highly recommending NOT to use this feature, as, for obvious reasons, the impact on performance might be dramatic.

Document information

More support for: Cognos Incentive Compensation Management
Cognos Incentive Compensation Management

Software version: 7.0.4, 7.1.1, 7.2.1, 7.3.0, 8.0, 8.0.1

Operating system(s): Windows

Reference #: 1636302

Modified date: 13 May 2013