Part of the process of customizing is localizing the interface, users can select a language on the sign-in page of BI Presentation Service. Many elements of the interface are automatically displayed in this language.
This user's setting is stored in the WEBLANGUAGE system session variable.
In an integrated Oracle BI application environment, the value of the WEBLANGUAGE variable is what determines the value of the LOCALE variable for externalized display names.
WEBLANGUAGE is initialized automatically, based on the language selected when a user logs in. You don't need to create an initalization block.
How the language value is determined ?
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 French logs in for the first time, then the value for WEBLANGUAGE is French, and the metadata is translated to French.
After the first logon, users can change the language setting on the Preferences tab of the My Account dialog.
For other clients
For other clients including third-party clients, the language is determined by the following precedence model:
- The language is set based on the WEBLANGUAGE session variable.
- If the WEBLANGUAGE session variable is not set, then the language is based on the language that is specified in the ODBC Data Source Name (DSN) that is used to access the Oracle BI Server.
- If an language has not been set in the ODBC DSN, then the language that is specified in the ORACLE_BI_LANG environment variable is used. To change the value of ORACLE_BI_LANG, update the character code for this variable in opmn.xml. You can view the character codes for supported languages in the ORACLE_HOME/bifoundation/server/locale directory (for example, “en” for English, or “pt-BR” for Portuguese/Brazilian).
- If the ORACLE_BI_LANG environment variable is not set, then messages are displayed in English.
Note that clients as the Administration Tool and Job Manager do not set the WEBLANGUAGE session variable.
In OBIEE - Instanceconfig.xml (Configuration Presentation Services):
<!-- To configure a limited set of languages to be available to users uncomment the <AllowedLanguages> tag below and choose a subset set of language tags from the list. Values must be comma separated. --> <!-- <AllowedLanguages>ar,cs,da,de,el,en,es,fi,fr,hr,hu,it,iw,ja,ko,nl,no,pl,pt,pt-br,ro,ru,sk,sv,th,tr,zh,zh-tw</AllowedLanguages> -->