Troubleshooting
Problem
A query item has the value 624425000 held in a numeric column on a database table.
The expression
_round([data_item]/1000000,2)
returns 624.42 when reporting in Report Authoring. The expected value is 624.43
Resolving The Problem
In Framework Manager, go to the Governor settings and set
Adjust SQL generation for exact numeric division
to
Do not adjust.
Further details of the Dynamic query mode governor settings can be found in the link below.
Related Information
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0, 11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
05 December 2019
UID
ibm11125363