Currency settings in OBIEE part 1

To set the default system currency

Note: It is a good idea to backup your configuration files before you make any changes.

• open currencies.xml located in ORACLE_BIHOME\bifoundation\web\display. e.g. on my machine, this is located in D:\OBIEE11g\Oracle_BI1\bifoundation\web\display\currencies.xml
• In currencies.xml file you will find a list of currencies defined by enclosing them in the <Currency> </Currency> tag. Locate the currency you want to make as the system default. e.g. we want to make Pound as the default currency

<Currency tag="loc:en-GB" type="local" symbol="£" locale="en-GB" format="$#" digits="2">
      <negative tag="minus" format="-$#" />
   </Currency>

• cut and paste this line just below the <Currencies> tag.
• next, search for the Currency tag which has the text tag="int:wrhs". locate this tag and comment it.
• replace the tag value in the pound currency from tag="loc:en-GB" to tag="int:wrhs". Your currency tag for pound should look like this

<Currency tag="int:wrhs" type="local" symbol="£" locale="en-GB" format="$#" digits="2">
<negative tag="minus" format="-$#" />
</Currency>

• Restart OBIEE presentation services.

Reference: OBIEE 11g System Administrator's Guide

Setting preferred currency option for an Analysis column in OBIEE Answers

create an Analysis in OBIEE answers involving the usage of a measure to be displayed as currency.

select F1 Revenu –> Column properties