By default the system currency of an OBIEE system is set to USD (dollar). Any amount that is displayed in a report, with the data setting set to Currency, is displayed with that default system currency symbol.
There is a way to change this to any currency you would like. My client wanted this to be set to the EUR (euro) currency.
To change the default system currency of OBIEE we need to change a configuration file for currencies, being the file currencies.xml. This file is located by default in the BI_HOME/bifoundation/web/display/ folder.
The default currency of OBIEE is set with the int:wrhs tag as can be seen in below screenshot.
You need to copy one of the currencies as defined in the currencies.xml file and set the tag value of the copied currency to int:wrhs. In this case we will copy the euro currency. The end result will be as below, it’s advisable to have your default currency also at the top of the file. You can comment out the old default currency with the <!– –> tags.
Restart the OBIEE presentation services to process your changes. From now on your amounts will be displayed with a new currency symbol.
