Reduce Decimal Precision

You can set decimal precision in crosstab reports.

In a crosstab report, values support a maximum of 18 digits, plus the decimal point. Decimal precision determines the number of the digits that are reserved to express the decimal component of a number. The remaining digits are reserved to express the integer component of the number. By default, the decimal precision is set to 7 digits, which restricts the length of integers to 11 digits.

If you want to reserve more than 11 integers to express the integer component of a number, you must reduce the decimal precision. For example, you may set the decimal precision to 2, which allows you to reserve up to 16 digits for the integer component of a number.

Procedure

In the c10_location\configuration directory, locate the qfs_config.xml file.
Copy the qfs_config.xml file, and rename the copied file to qfs_config.xml.backup.

Open the original qfs_config.xml file, and find the following line of code:

<provider name="CubeBuildProvider"libraryName="qfsCubeBuildProvider"
serviceProvider="true"> 
    <providerDetails>

For the providerDetails element, add the following line:
```
<scaleOfFloatDouble value="n"/>
```
where "n" represents the decimal precision value that you want to specify.

The default value is 7.
Save the qfs_config.xml file.
Restart the IBM® Cognos® service.