Localize the User Interface for Presentation Services

You can localize the user interface for Presentation Services, if your users speak languages other than English.

Users can select a language on the sign-in page for Oracle Analytics, 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 Presentation Services user interface, WEBLANGUAGE is set when a user selects a language on the sign-in page.

Note:

For Oracle Applications, 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 to Oracle Applications for the first time, then the value for WEBLANGUAGE is French, and the metadata is translated to French.

As the administrator, you perform various tasks to localize other elements of the user interface for Presentation Services, as described in the following sections:

• Understand the Directory Structure to Localize Presentation Services

• Localize Messages for Users' Preferred Currency

• Specify the Default Language for the Sign-In Page

• Specify the Language in the URL

Understand the Directory Structure to Localize Presentation Services

Oracle Analytics Server is installed with many files that control elements in the user interface and messages.

These files are installed in the messages and pages subdirectories of the ORACLE_HOME/bi/bifoundation/web/msgdb directory. To localize these elements and messages, you copy those files to the l_xx subdirectories in SDD/components/OBIPS/custommessages/l_xx

where SDD is the Singleton Data Directory, and _xx indicates the language extension. See Key Directories. After you have copied the files, you can modify their contents as appropriate for the language that corresponds to the subdirectory in which you have copied them.

Localize Messages for Users' Preferred Currency

You can localize the messages that are associated with a preferred currency.

See Define User-Preferred Currency Options Using a Static Mapping for information on working with users' preferred currencies.

1. Go to the SDD/components/OBIPS/custommessages/l_xx directory, where xx is the language extension for the language in which you are specifying preferred currencies.

   Where SDD is the Singleton Data Directory for example, DOMAIN_HOME/bidata. See Key Directories.

2. In the directory, create a subdirectory called custommessages.
3. In the directory, create a file in XML format, with the name of usercurrencymessages.xml.
4. Add entries such as the following one to this file for the language that corresponds to the directory in which you are working. The following example includes two messages: kmsgMyCurrency1 and kmsgMyCurrency2

   <?xml version="1.0" encoding="utf-8"?>
   <WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
   <WebMessageTable system="CurrencyDisplay" table="Messages" code="false">
      <WebMessage name="kmsgMyCurrency1"><TEXT>My Currency Text 1</TEXT></WebMessage>
      <WebMessage name="kmsgMyCurrency2"><TEXT>My Currency Text 2</TEXT></WebMessage>
   </WebMessageTable>
   </WebMessageTables>
   

5. Edit the file to specify displayMessage="kmsgMyCurrency1" to use this message.
6. Repeat Steps 1 through 5 for each language for which you must localize these messages.
7. Restart the service for Oracle BI Presentation Services.

In Oracle Analytics Server, the appropriate localized text is displayed to the user. In this example, the text is My Currency Text 1.

Specify the Default Language for the Sign-In Page

You can change the language the user sees by overriding the language specified by their browser.

The default language in which the Presentation Services sign-in page is displayed is obtained from the user's client browser settings.

Update your browser's Internet Options settings to change the language specified by your browser.

Specify to Scale Numbers in Performance Tiles

In Presentation Services, you can use performance tiles to focus attention on a single piece of high-level aggregate data.

The tile can include a number such 1,000,000 or you can specify to "compress" or "scale" the value with an indicator such as 1M, for example.

To scale the number, Presentation Services searches for the scaling factors that the current locale allows, processes the number, and appends the indicator value. If no scaling factors are defined for the current locale, then no scaling is applied. Because the scaling of numbers differs by language, you can manually edit the localedefinitions.xml file to control the scaling, as described in the following procedure.

1. In a text editor, open the localedefinitions.xml file in the directory:

   ORACLE_HOME/bi/bifoundation/web/display

2. In the file, add a new property for "scaleFactors" and enter values appropriate to your locale.

   The following shows values for an English locale:

   <localeDefinition name="en">
       <!-- existing data -->
           <property name="scaleFactors">
               <property name="thousand">K</property>
               <property name="million">M</property>
               <property name="billion">B</property>
               <property name="trillion">T</property>
               <property name="quadrillion">Q</property>
               <property name="quintillion">Qu</property>
               <property name="sextillion">S</property>
               <property name="septillion">Sp</property>
               <property name="octillion">O</property>
               <property name="nonillion">N</property>
               <property name="decillion">D</property>
               <property name="undecillion">UD</property>
               <property name="duodecillion">DD</property>
           </property>
   </localeDefinition>
   

   The following shows values for an Indian locale:

   <localeDefinition name="en-in" basedOn="en">
       <!-- english - india -->
       <!-- existing data -->
           <property name="scaleFactors">
               <property name="thousand">K</property>
               <property name="hundred-thousand">L</property>
               <property name="ten-million">Cr</property>
           </property>
   </localeDefinition>
   

3. Save your changes and close the file.
4. Restart Presentation Services.

Specify the Language in the URL

When users start Oracle Analytics Server by displaying the sign-in page, they can select the language as part of the sign-in process.

Users can also select a language on the Preferences tab of the My Account dialog.

If you provide users with a URL with which they can display a dashboard or other page of the application, then you can define a URL parameter as a profile attribute. Doing so dynamically sets the language of the dashboards and analyses to be consistent with the application's language setting.

For operational applications, symbolic URLs embed dashboards and analyses in the integrated environment. For Oracle BI Presentation Services, the URL parameter Lang designates the language that the web page renders.

The Lang parameter can be included in the symbolic URL that is defined in the operational application to connect to Oracle Analytics Server. The Lang parameter is defined as a profile attribute, but when the symbolic URL is constructed at runtime, the value is set as the profile attribute LanguageCode. The next table provides examples of the parameter settings in the Symbolic URL parameters applet, including Lang.

For example, the following URL displays the sign-in page in French.

http://Server_Name:port_number/analytics/saw.dll?Dashboard&Lang=fr

Name	Type	Path Argument Value	Append	Sequence #
Cmd	Constant	Go	Y	1
Path	Constant	/shared/Sales/Pipeline/Overview/Top 10 Deals	Y	2
nQUser	Command	UseLoginId	Y	3
nQPassword	Command	UseLoginPassword	Y	4
PostRequest	Command	PostRequest	Y	5
Lang	Profile Attribute	LanguageCode	Y	6