OBIEE 10G/11G - WEBLANGUAGE system session variable

Obi Edition


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.

Obiee Preference Myaccount Locale Weblanguage

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.


Value Language
cs Czech
da Danish
de German
en English
es Spanish
fi Finnish
fr French
it Italian
ja Japanese
ko Korean
nl Dutch
pt Portuguese
pt-br Brazilian Portuguese
sv Swedish
zh Chinese (Simplified)
zh-tw Chinese (Traditional)


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> -->

Documentation / Reference

Discover More
Obi Edition
OBIEE - Localization

localization refers to the process of adapting the Oracle Business Intelligence deployment to a particular language. Part of the process of customizing is localizing the interface, if...
Obiee11g System Session Variable
OBIEE - System session variables (reserved variables)

System session variables are session variables that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names, that cannot be used...
Obiee Preference Myaccount Locale Weblanguage
OBIEE 10G/11G - LOCALE system session variable

The locale variable in the context of OBIEE. It's a system session variable and is used for functions such as: displaying dates and currencies and sorting data. Some locale- and language-related...
Obiee Path
OBIEE 10G/11G - The Go URL

The Go URL is a part of the saw Url and is used to : add an answer in your favorites, link an answer to an other answer issue sql pass filters integrate an answers into an external Web site...
Obiee Caption Prompt
OBIEE 10G/11G - Translate the WebCat (Dashboard, page and report names)

To locate Oracle BI Presentation Catalog Captions (ie dashboard, page and report names (webcat metadata translation), you must : check the custom header checkbox for all column formulas that appears...
Obiee11g Lookup Table
OBIEE 11G - Lookup Function

A lookup in OBIEE is performed: in 10g with the help of a outer of inner join in 11G with the lookup function In 11g, the lookup function was introduced in a localization perspective. It permits...

Share this page:
Follow us:
Task Runner