Skip Headers
Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)

Part Number E10541-07
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

16 Configuring Currency Options

This chapter describes how to configure currency options in Oracle Business Intelligence. When content designers create analyses, they often include data that shows currency, such as American dollars. As the administrator, you can perform various tasks that affect currency options that are available to users.

This chapter includes the following sections:

16.1 Changing the Default Currency for Analyses

You can change the default currency that is displayed, for example, from French Francs to Euros. For information about using formatting functions in Answers, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.

To set the default currency:

  1. Open the currencies.xml file in the directory
    ORACLE_HOME\bifoundation\web\display.

  2. Search for the currency to make the default, for example, USD, CAD, PEN, or MAD.

  3. Copy the entire currency element.

    For example, copy the currency tag for the Euro:

    - <Currency tag="int:euro-l" type="international" symbol="_" displayMessage="kmsgCurrencyEuroLeft" digits="2" format="$ #">
    <negative tag="minus" format="-$ #" />
    </Currency>
    
  4. Search for the text string int:wrhs, located near the top of the file.

  5. Select the entire element and replace it by pasting the copied element over it.

  6. Replace the tag attribute so it reads int:wrhs.

    For example, replace tag="int:euro-l" with tag="int:wrhs".

  7. Restart the service for Oracle BI Presentation Services.

To specify the currency for a column in a customized subject area:

  1. In Answers, modify the analysis that uses the subject area.

  2. In the Analysis editor: Criteria tab, click the Options button for the currency column and select Column Properties to display the Column Properties dialog.

  3. Click the Data Format tab and select the Override Default Data Format box.

  4. In the Treat Numbers As box, select Currency.

  5. In the Currency Symbol list, select the symbol.

  6. Complete the other options on the tab as appropriate.

  7. If desired, save this setting as a systemwide default.

  8. Click OK when you have finished, and repeat the preceding steps for any other columns to change.

16.2 Defining User-Preferred Currency Options

Users can select the currency in which they prefer to view currency columns in analyses and dashboards in two ways:

Figure 16-1 Example of the Currency Box on the My Account Dialog: Preferences Tab

Description of Figure 16-1 follows
Description of "Figure 16-1 Example of the Currency Box on the My Account Dialog: Preferences Tab"

For information about setting the currency preference on the My Account dialog: Preferences tab or about currency prompts, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.

You define the currency options that are to be displayed in the Currency box and in a currency prompt in the userpref_currencies.xml file. (These currency options must be for currencies to which your installation can convert columns.) Defining the currency options also controls whether the Currency box is available on the My Account dialog: Preferences tab and whether the Currency Prompt option is available on the Definition pane of the Prompt editor.

When you define these currency options, you can use one of two types of mappings:

Note:

For the user-preferred currency options to take effect, the following configuration also must be done in the Oracle Business Intelligence repository:

  • Creation of the PREFERRED_CURRENCY session variable

  • Conversion setup of logical currency columns in the Business Model and Mapping layer

  • Creation of the userCurrencyPreference table using the currency information from your installation that enables you to dynamically change the currency options based on a logical SQL statement that you specify (required only if you use a dynamic mapping)

For information, see "Configuring Logical Columns for Multicurrency Support" in Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.

16.2.1 Defining User-Preferred Currency Options Using a Static Mapping

You can use a mapping to define a static list of options that all users see for selecting currency.

To define the user-preferred currency options using a static mapping:

  1. Use a text editor to open the userpref_currencies.xml file located in the following directory:

    ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn

  2. Add a UserCurrencyPreferences element as follows:

    <UserCurrencyPreferences currencyTagMappingType="static">
    
    </UserCurrencyPreferences>
    
  3. For each currency option to be displayed in the Currency box or in currency prompts, add a UserCurrencyPreference element between the <UserCurrencyPreferences> tags using this format:

    <UserCurrencyPreference sessionVarValue="sessionVarValuevalue" displayMessage="displayMessagevalue" displayText="displayTextvalue" currencyTag="currencyTagvalue"/> 
    

    In this format:

    • sessionVarValue="sessionVarValue " sets the session variable PREFERRED_CURRENCY. For its value, specify a string that uniquely identifies the currency, for example, gc1.

    • (optional) displayMessage="displayMessagevalue" sets the presentation variable currency.userPreference to a localized value. To specify a localized value, you first must create the localized message for the currency in the usercurrencymessages.xml file. For information, see Section 15.2.1.2, "Localizing Messages for Users' Preferred Currency." Then, for the value of displayMessage, specify the WebMessage name that is identified in the usercurrencymessages.xml file for the currency. For example, if you created this English language entry in the usercurrencymessages.xml file:

      <WebMessage name="kmsgMyCurrency1"><TEXT>My Currency 1</TEXT></WebMessage> 
      

      Then you would specify kmsgMyCurrency1 as the value of displayMessage.

    • (optional) displayText="displayTextvalue" sets the presentation variable currency.userPreference to a value that is not localized. For its value, specify a string that identifies the currency, such as Global Currency 2.

      For more information about the currency.userPreference variable, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition

    • currencyTag="currencyTagvalue" identifies the Currency Tag in the currencies.xml file whose displayMessage value is to be used to populate the Currency box on the My Account dialog: Preferences tab and currency prompts. (The currencies.xml file, which is located in ORACLE_HOME\bifoundation\web\display, provides currency formats.)

    Note:

    The value of the currency.userPreference variable is obtained from the displayMessage and displayText attributes of the UserCurrencyPreference element using the following order of precedence:

    1. displayText

    2. displayMessage

    If no values exist for displayText and displayMessage, then the value of the displayMessage attribute for the corresponding currency tag in the currencies.xml file is used.

  4. Save and close the userpref_currencies.xml file.

  5. Restart Oracle Business Intelligence.

    For information, see Section 4.1, "About Starting and Stopping Oracle Business Intelligence."

16.2.2 Example: Static Mapping to Define User-Preferred Currency Options

The following example shows a userpref_currencies.xml file that uses a static mapping to define user-preferred currency options:

<UserCurrencyPreferences currencyTagMappingType="static">
   <UserCurrencyPreference sessionVarValue="gc1" displayText="Global Currency 1" currencyTag="int:USD" />
   <UserCurrencyPreference sessionVarValue="gc2" displayText="Global Currency 2" currencyTag="int:euro-l" />
   <UserCurrencyPreference sessionVarValue="gc3" displayText="Global Currency 3" currencyTag="loc:ja-JP" />
   <UserCurrencyPreference sessionVarValue="orgc" displayText="Org Currency" currencyTag="loc:en-BZ" /> 
</UserCurrencyPreferences>

Figure 16-2 shows how these values from the userpref_currencies.xml file are displayed in a drop-down list of currency options for a prompt on a dashboard page. The drop-down list is similar to what is displayed for the Currency box on the My Account dialog: Preferences tab.

Figure 16-2 Static Currency Options in a Prompt

Description of Figure 16-2 follows
Description of "Figure 16-2 Static Currency Options in a Prompt"

16.2.3 Defining User-Preferred Currency Options Using a Dynamic Mapping

You can use a mapping to define a dynamic list of options that users see for selecting currency. The list changes dynamically based on a logical SQL statement that you specify. This is useful, for example, to dynamically change the currency options based on the user.

To define user-preferred currency options using a dynamic mapping:

  1. Use a text editor to open the userpref_currencies.xml file that is located in the following directory:

    ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn

  2. Add a UserCurrencyPreferences element as follows:

    <UserCurrencyPreferences currencyTagMappingType="dynamic">
    
    </UserCurrencyPreferences>
    
  3. Add a UserPrefCurrencyLogicalSQL element between the <UserCurrencyPreferences> tags using this format:

    <UserPrefCurrencyLogicalSQL>
    SELECT column1, column2, column3 FROM userCurrencyPreference
    </UserPrefCurrencyLogicalSQL>
    

    In this format:

    • column1 contains the values that are used to set the session variable PREFERRED_CURRENCY. Each value in this column is a string that uniquely identifies the currency, for example, gc1.

    • column2 contains the currency tags in the currencies.xml file whose displayMessage values are to be used to populate the Currency box and currency prompts, for example, int:euro-1. (The currencies.xml file, which is located in ORACLE_HOME\bifoundation\web\display, provides currency formats.)

    • (optional) column3 contains the values used to set the presentation variable currency.userPreference. Each value in this column is a string that identifies the currency, such as Global Currency 2.

      Note:

      If you omit column3, then the values for the displayMessage attributes for the corresponding currency tags in the currencies.xml file are used.

      For more information about the currency.userPreference variable, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition

  4. Save and close the userpref_currencies.xml file.

  5. Restart Oracle Business Intelligence.

    For information, see Section 4.1, "About Starting and Stopping Oracle Business Intelligence."

16.2.4 Example: Dynamic Mapping to Define User-Preferred Currency Options

The following example shows a userpref_currencies.xml file that uses a dynamic mapping to define user-preferred currency options:

<UserCurrencyPreferences currencyTagMappingType="dynamic">
UserPrefCurrencyLogicalSQL>
<!-- In this SELECT statement, column1 contains the values to set the PREFERRED_CURRENCY variable, column2 contains the currency tag values, and column3 contains the values to set the currency.userPreference variable. --> 
SELECT markets.userpreferences, markets.currencyTag, markets.userpreferencename FROM userCurrencyPreference
</UserPrefCurrencyLogicalSQL>
</UserCurrencyPreferences>

Table 16-1 shows sample results from the logical SQL statement.

Table 16-1 Sample Logical SQL Results

"Markets"."UserPreference" "Markets"."CurrencyTag" "Markets"."UserPreferenceName"

varchar

varchar

varchar

orgc1

loc:en-BZ

Org currency

gc2

int:euro-1

Global currency 2

lc1

int:DEM

Ledger currency

gc1

int:USD

Global Currency 1


Figure 16-3 shows how the values that are generated dynamically from the SQL statement in the userpref_currencies.xml file are displayed in a drop-down list of currency options for the Currency box on the Preferences tab of the My Account dialog. The drop-down list is similar to what is displayed for a prompt on a dashboard page.

Figure 16-3 Dynamic Currency Options in the My Account Dialog

Description of Figure 16-3 follows
Description of "Figure 16-3 Dynamic Currency Options in the My Account Dialog"