Multi Language Support(Localization)(Presentation Services)

One of the foremost important features in OBIEE is Localization i.e. Multi country implementation .It’s a robust feature indeed to make the application reusable across several countries in multi country roll-out deployment and thus internationalizing the application.

The Oracle Business Intelligence Presentation layer supports multiple language translations for any presentation column name and column description. When working with Oracle BI Answers or rendering a dashboard, users should see their local language strings in their reports. For example, English-speaking and French-speaking users would see their local language strings in their reports. There are two kinds of application strings required for the translation in Oracle Business Intelligence:

Metadata Strings:

Metadata strings are Analytics-created objects in the Oracle Business Intelligence repository objects such as Subject Area, Metrics, and Dimensions etc.

Presentation Services (Localizing Presentation Catalog Captions):

Presentation Services objects are end-user created objects such as Reports, Dashboards, and Pages. Translations for Presentation Services strings are stored in the captions.xml file. How this could be accessed can be found from Oracle BI Presentation Service Admin Guide.

WEBLANGUAGE system session variable:

For Presentation Services the language is set based on the WEBLANGUAGE session variable. WEBLANGUAGE is set to the language of the user's browser when a user logs in for the first time. For example, if a user with a browser language set to Japanese logs in for the first time, then the value for WEBLANGUAGE is Japanese, and the metadata is translated to Japanese.

Multi Language Support (Repository)

1. Table name and column names are showing in the left pane. So in the report or dashboard the table and column names are display in Japanese format.
2. Table name [生産表] production table
3. Column header also showing in Japanese format.

Below the dropdown is listing LOB’s in Japanese format. All choices option is showing here in English, when we change the Localization from English to Japanese, then the all choices will show in Japanese.

Below I have selected the LOB as ‘Liability Litigation’ and the result also showing based on that.