The operating system locale setting determines the run locale for IBM Cognos 8 server requests, as well as the current code page for Transformer. To change the system locale on Windows, you must update the Regional and Language Options, including the language for non-Unicode programs. Changing these settings on Windows requires that you restart the computer. On UNIX systems, you can change the locale without restarting the computer.
To display the run locale Transformer is currently using, view the Session Information available from the File menu. For example, if the locale is set to English (Canada), the run locale will be en-ca. Transformer sends the run locale in its requests to the IBM Cognos 8 server. When Transformer is requesting data from a multilingual package or report, the run locale may be used to determine the language in which data is returned.
Note: When a report is authored, the author chooses a content locale. This content locale is saved with the report and is the locale in which the metadata is expressed when Transformer accesses the report. As a result, ensure that reports used as data sources in Transformer have the appropriate content locale.
By default, Transformer builds PowerCubes in the current code page as determined by the locale settings. On many UNIX and Linux systems, the default code page is UTF-8. Transformer 8.x can build PowerCubes in the UTF-8 code page, which is a Unicode encoding. The resulting cube is not a multilingual cube; it is a unilingual cube in the UTF-8 code page. IBM Cognos Series 7 products are unable to read PowerCubes that use the UTF-8 code page. To build PowerCubes in a code page that is different than the current code page, you can change the Cube code page setting on the Model properties sheet. For example, you can build a windows-1252 code page PowerCube on Linux so that IBM Cognos Series 7 products can use the cube.
Transformer supports Unicode data sources, including Framework Manager packages, IBM Cognos 8 reports, and exported .csv files from IBM Cognos 8 reports. Transformer converts the Unicode data to the code page of the current locale for processing and display, and will also convert the data to a cube code page if one is specified. You must use compatible code pages, otherwise character loss may occur. For example, you should not process Japanese text data when Transformer is running in an English locale.