Troubleshooting
Problem
Transformer uses the system locale to set the encoding of a Powercube. Powerplay displays data based on the Operating System Locale, not on the Powercube encoding. Cognos needs to explicitly convert Powercube data into Unicode. Powercubes built on an English Operating System will be assigned as Windows-1252 encoded, so multi-byte Korean or other language strings will be displayed as if they were special Latin-1 characters, hence you will see accented characters in the corrupted strings.
Resolving The Problem
Always build Powercubes using Transformer with the System Locale set to match the Locale of the data being ready by the Model. You can use the English version of Transformer but the System Locale needs to be set correctly for the conversion to Unicode to work correctly in Cognos.
The advantage of this is you can have Powercubes from multiple locales used in the same Cognos environment.
In Windows, Regional Settings, set System Locale to the to the language of the data being read.
Related Information
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21371246