Sunday, January 20, 2013

[OBIEE11g] - Change the placement of currency name


Usually currency symbol is shown before the currency value ($1000) and currency name appears after the value (15000 USD). In OBIEE,currency name/symbol formatting is handled by currency.xml

Have a look at this report.











In my case currency name is INR.

I want INR to be appeared before the AMOUNT_SOLD column value. 

Let us go and open the currency.xml and search for the currency name INR.











Edit the highlighted line. Add a tag : format="$ #"

This will look like:







Save the changes. Restart the BI services. Reload the metadata and clear the browser cache.

Now let's look at the result.