Siebel Reports Guide > Administering Siebel Reports > Administering Multilingual Reports >

Creating Multilingual Reports

You create a multilingual report in the same way that you create a report that is not multilingual. The only difference is that you must externalize the user interface elements so that they support multiple languages in the locales that you require. For more information about externalizing the user interface elements, see How Siebel CRM Translates User Interface Elements. For more information about designing reports, see Customizing Siebel CRM Reports.

If you add a locale to a report template, then Siebel CRM creates a separate report for each locale that you add. It creates these reports in addition to the report it creates according to the priority described in Priority That Determines the Report Language.

To create a multilingual report

1. Navigate to the Administration - Data screen, and then the List of Values view.
2. Query for XMLP_RPT_OUTPUT_TYPE and set the Display Value setting to ALL.
3. Select the following check boxes:
   • Active
   • Translate
   • Multilingual
4. (Optional) Repeat Step 2 and Step 3 for each output type you require.
5. Design a report in the default language.

   ENU (English U.S.) is an example of a default language.

6. Use Oracle BI Publisher Desktop to redesign the report template so that it can accommodate the spatial layout of the primary language that your deployment uses.

   For more information, see About Oracle BI Publisher Desktop.

7. (Optional) Use BI Publisher Desktop to add a default locale to the report template:
   1. Use Oracle BI Publisher Desktop to open the report template.
   2. In the Oracle BI Publisher menu, choose Tools, Translate Template, and then Localize Template.

• Do the work described in Registering Report Templates, with the following differences:
  • Use the following format when you name the XLIFF or RTF file that you upload:

  TemplateName_language code_TERRITORY CODE.extension

  where:

  • TemplateName is the name of the report template.
  • language code is a lower-case, two-letter ISO language code.
  • TERRITORY CODE is an upper-case, two-letter ISO country code.
  • extension is xlf or rtf.

    For example, if the template name is EmployeeTemplate, and if you must upload a Japanese-Japan translation, then use the following file name:

  EmployeeTemplate_ja_JP.xlf

  • Use the following format when you name the ZIP file that you upload:

  report template file name.zip

  Files names are not case-sensitive.

  • In the child Translations list, click New to add a new language.
    • In the Language field, add a new language, and then click OK.
    • (Optional) Enter a Report Name.

      Siebel CRM displays the name you enter for the translated report in the Run Report pane.

      CAUTION:  Each translated report must include a unique, translated display name. If duplicate names for a translated report exists, then the Siebel Server cannot determine the report to run when Siebel CRM sends these names from the browser to the Siebel Server, and the report might fail.

      When you click Upload, Siebel CRM does the following work according to the type of file you upload:

  • RTF file. Stores the RTF file in the SIEBEL_ROOT\XMLP\TEMPLATES folder, and then uploads the RTF and XLIFF files a language subfolder on the Oracle BI Publisher Server.
  • ZIP file. Stores the ZIP file in the SIEBEL_ROOT\XMLP\xliff folder, and then decompresses this file to the following folder:

  SIEBEL_ROOT\XMLP\xliff\language_code

  For more information about this directory structure, see Directory Structure That Siebel Reports Uses.

  Siebel CRM validates these files during the upload. If it finds an error, then it displays an error message and deletes the uploaded files. For information about this validation, see Validations That Siebel CRM Does When You Upload a Report Template.

  • When you validate the directory structure of the Oracle BI Publisher Server, note that Siebel CRM uses the following format to register each XLIFF file:

  TemplateName_language code_TERRITORY CODE.xlf

  For more information about using this format, see Oracle Business Intelligence Publisher Report Designer's Guide on Oracle Technology Network (http://www.oracle.com/technetwork/indexes/documentation/index.html).