|
Cognos 8 Powercube data is not displayed in correct characterset |
|
|
|
Wednesday, 11 November 2009 20:30 |
|
Symptom Dimension names are displayed with strange/invalid characters in Cognos 8, while in PowerPlay client, the dimension names are correctly Cause Transformer embeds a characterset identifier into the generated mdc file. This is based on the locale defined in Configuration Manager->Cognos Shared->Locale. This is used by Cognos 8 to convert the cube characterset to Unicode. If the embedded characterset identifier does not match the actual coding of the data or it does not match the OS locale, mismatches may occur. The data in PowerPlay on the same machine as Transformer may still display fine as there is no chracterset conversion occurring. Solution Make sure that the Operating System locale and the locale defined in Configuration manager on the Transformer machine match the coding of the data used to generate the cube. www.cogknowhow.com
|
Comments