OBIEE - Localization

Obi Edition

About

localization refers to the process of adapting the Oracle Business Intelligence deployment to a particular language.

BI Presentation Services

Part of the process of customizing is localizing the interface, if your users speak languages other than English. Users can select a language on the sign-in page for Oracle BI EE, and many elements of the interface are automatically displayed in the appropriate language. After signing in, users can change the language setting on the Preferences tab of the My Account dialog.

The user's setting is stored in the WEBLANGUAGE session variable. For the Oracle BI Presentation Services user interface, WEBLANGUAGE is set when a user selects a language on the sign-in page.

Mapviewer

You can use the functionality of MapViewer to label the features of a theme (called a layer for maps in Oracle BI EE) using a specific language or locale.

BI Server

The General section of the NQSConfig.INI file contains parameters that are required for localization and internationalization. It also contains default parameters that determine how data is sent from the Oracle BI Server to a client application.

The following parameters in the NQSConfig.INI file affect localization:

  • SORT_ORDER_LOCALE. (The value to use for the C-run-time locale during server startup)
  • SORT_TYPE
  • CASE_SENSITIVE_CHARACTER_COMPARISON

Some locale- and language-related settings are interrelated and help determine how the Oracle BI Server sorts data.

Formula

OBIEE - Case When Statement

CASE WHEN VALUEOF(NQ_SESSION.WEBLANGUAGE) = 'en' THEN 'Hello' 
WHEN VALUEOF(NQ_SESSION.WEBLANGUAGE) = 'nl' THEN 'Hallo'
..etc..
END

Reference / Documentation





Discover More
Saw Object
OBIEE - BI Presentation Service (SAW/OBIPS)

AnswersInteractive DashboardsDelivers The Oracle BI Presentation Service Server: is a pure Web Environment visualize data from the Oracle BI Server through the creation of Interactive Dashboards...
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 10.1.3.4.1 and higher versions, Dashboard Prompt input formats and presentation variable values...
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...
Obiee11g Architecture Functional Component
OBIEE 11G - New Features and changes 11G

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is the most significant release of OBIEE since 2006. This article contains the significant changes and new features of OBIEE 11g. Oracle...



Share this page:
Follow us:
Task Runner