OBIEE 10G/11G - LOCALE system session variable

Obi Edition


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 settings are interrelated and help determine how the Oracle BI Server sorts data.

Default value

Users can change the locale setting on the Preferences tab of the My Account dialog.

Obiee Preference Myaccount Locale Weblanguage


For BI Presentation Service

In OBIEE - Instanceconfig.xml (Configuration Presentation Services):

<!-- To configure a limited set of locales to be available to users uncomment the <AllowedLocales> tag below
 and choose a subset set of locale tags from the list. Values must be comma separated. -->

<!-- <AllowedLocales>ar-dz,ar-bh,ar-dj,ar-eg,ar-iq,ar-jo,ar-kw,ar-lb,ar-ly,ar-ma,ar-om,ar-qa,ar-sa,ar-so,
th-th,tr-tr,zh-cn,zh-mo,zh-sg,zh-tw</AllowedLocales> -->

For BI Server

You can find it in the General section of the NQSConfig.INI file.

Documentation / Reference

Recommended Pages
Obiee Filter On Date
OBIEE - Date Format in presentation variable, dashboard prompt and logical SQL

This article talk the manipulation of a presentation variable with a date datatype. Starting with OBIEE and higher versions, Dashboard Prompt input formats and presentation variable values...
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 - WEBLANGUAGE system session variable

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...
Obiee11g Descriptor Id Column
OBIEE 11G - Double column (Descriptor Id)

Double column support is the ability in the logical layer to associate two columns: a descriptor or display column. It contains the display/description values. For example, the description of an item....

Share this page:
Follow us:
Task Runner