Oracle^® Business Intelligence Presentation Services Administration Guide > Administering Oracle BI Answers >

Changing the Default Currency in Answers

You can change the default currency displayed in the Answers user interface, for example, from French Francs to Euros.

If you are using Oracle Business Intelligence applications, with no customizations, you only need to set the default data warehouse currency.

If you have created additional subject areas, the currency column data is in the number format, and you need to specify the currency for the customized subject area as described in the second procedure.

For more information about using formatting functions in Answers, read Oracle Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide.

To set the default data warehouse currency

1. Open the currencies.xml file in the directory \\SAROOTDIR\web\config, where SAROOTDIR is the installation directory.
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 towards 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 customized subject areas

1. In Answers, modify the request that uses the subject area.
2. Click the Format Column button for the currency column.

   The Column Properties dialog box appears.

3. At the Value Format tab, in the Data Format area, click the following option:

   Override Default Data Format

4. In the Treat Numbers As drop-down list, select Currency.
5. In the Currency Symbol drop-down list, select the currency symbol.
6. To save this as the system-wide default for this data type, click Save, and then select the appropriate option.
7. Click OK when you are done, and then repeat the preceding steps for any other columns to change.