To use Cognos product documentation, you must enable JavaScript in your browser.

Reduce Decimal Precision

In cross tab reports, values may contain a maximum of 19 total digits. Decimal precision determines how many of these digits are reserved for expressing the decimal component of a number with the remaining digits available to express the integer component.

By default, decimal precision is set to 7 digits, which restricts the length of integers to 11 digits (since one digit is reserved for the decimal separator). If you want to use more than 11 integers, you must reduce the decimal precision. For example you may choose to set decimal precision to 2, which allows you to express up to 16 digits of integers.

Steps

  1. Copy the c8_location/configuration/CQEConfig.xml.sample file to c8_location/bin and rename it CQEConfig.xml.

  2. Open the c8_location/configuration/CQEConfig.xml in an editor.

    Ensure that your editor supports saving files in UTF-8 format.

  3. Find the crosstabDecimalPrecision parameter and decrease the value to the decimal precision that you want.

  4. Save the CQEConfig.xml file.

  5. Using Cognos Configuration, stop and then restart Cognos 8.

    For information about stopping Cognos 8, see the Installation and Configuration Guide.