Setting up a Multilingual Reporting Environment

You can create reports that show data in more than one language and use different regional settings. This means that you can create a single report that can be used by report consumers anywhere in the world.

The samples databases provided with IBM® Cognos® store a selection of text fields, such as names and descriptions, in more than 25 languages to demonstrate a multilingual reporting environment. For information about how data is stored in the samples databases and how the samples databases are set up to use multilingual data, see the IBM Cognos Analytics Administration and Security Guide.

Here is the process for creating a multilingual reporting environment:

  • Use multilingual metadata.

    The data source administrator can store multilingual data in either individual tables, rows, or columns.

    For more information about configuring your database for multilingual reporting, see the IBM Cognos Analytics Administration and Security Guide.

  • Create a multilingual model.

    Modelers use Framework Manager to add multilingual metadata to the model from any data source type except OLAP. They add multilingual metadata by defining which languages the model supports, translating text strings in the model for things such as object names and descriptions, and defining which languages are exported in each package. If the data source contains multilingual data, modelers can define queries that retrieve data in the default language for the report user.

    For more information, see the IBM Cognos Framework Manager User Guide.

  • Create a multilingual report.

    The report author uses Reporting to create a report that can be viewed in different languages. For example, you can specify that text, such as the title, appears in German when the report is opened by a German user. You can also add translations for text objects, and create other language-dependent objects.

    For more information, see the IBM Cognos Analytics - Reporting User Guide.

  • Specify the language in which a report is viewed.

    You can use IBM Cognos Analytics portal to do the following:

    • Define multilingual properties, such as a name, screen tip, and description, for each entry in the portal.
    • Specify the default language to be used when a report is run.

      Tip: You can specify the default language on the run options page, in the report properties, or in your preferences.

    • Specify a language, other than the default, to be used when a report is run.

    For more information, see the IBM Cognos Analytics Getting Started guide.

The data then appears in the language and with the regional settings specified in

  • the user's Web browser options
  • the run options
  • the IBM Cognos Analytics portal preferences

Any text that users or authors add appears in the language in which they typed it.