Pages

Thursday, December 27, 2012

Changing the placement of currency name

Usually currency symbol is shown before the currency value ($1000) and currency name appears after the value (1200 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.
 


No comments:

Post a Comment