Troubleshooting
Problem
Customer has decided to use the new (since version 10.4.2) standard report engine 'Embedded Report Library'.
- In other words, they have configured 'web.config' to use "ccrReports" (see separate IBM Technote #1489047).
Customer is based in a geography (for example Sweden) where the 'thousand separator' (for numbers) is traditionally something other than comma.
- For example in Sweden it is a 'space' ( )
Therefore, to achieve this, the customer modified the regional settings (of both the client device and the Controller application server) to the appropriate value (for example "Swedish (Sweden)")
Afterwards, unfortunately, when standard reports are run, all numbers appear with comma separating groups of numbers (for example: 1,234,567) instead of the expected: 1 234 567
Symptom
For example, imagine a scenario where the user clicks 'Reports - Ad Hoc' and then runs a report.
When using new 'Embedded Report Library':
...or zoomed in:
Compare this to when using Cognos Analytics as the report server:
As you can see (above) Cognos Analytics groups the numbers using a space separator, when the regional settings tell it to use a space (for example 'Swedish (Sweden)'.
Cause
Limitation (reference APAR PH23266) of Controller.
It is not possible to reconfigure the 'Embedded Report Library' report engine to separate number grouping other than with commas (,).
Environment
Controller 10.4.2 (or later).
Resolving The Problem
Fix:
Known limitation of Controller.
Workaround:
Reconfigure Controller to use the traditional 'Cognos Analytics' method of displaying standard reports.
Related Information
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
13 March 2020
UID
ibm15736855