Product:
IBM Cognos BI 10.1.1
AIX server
Oracle database
Symptom:
You run cognos BI reports, but they do not show names that contain local characters like åäö.
The åäö is replaced with blank, or the product name is not show at all in the report.
Problem:
Only exist on AIX server with Oracle database using Cognos BI 10.1.1
Can be because of how the Oracle database regions settings are configured.
Possible Solution:
In the profile for the service user account running the Cognos BI service, you need to set a variable to tell Cognos to use a different language for data it fetch from the database.
On AIX this is set by parameters in the .profile file for the user running the Cognos service.
Log in as root user on AIX server.
Go to the HOME folder of the user account.
Open the .profile file in text editor.
Add this line below # Cognos specific configuration line:
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export NLS_LANG
Save the file.
Restart the Cognos service.
More information
http://www-01.ibm.com/support/docview.wss?uid=swg21343177