Hi All,
Our current datawarehouse contains moneis all in dollars, but soon will be mixed with other foreign currencies. Is there (hopefully) an easy way to convert them to dollars in BO without having the users creating variables or other things?
Thanks for all your help,
Edna
Oracle 7.3.4
BO 4.1.5
Listserv Archives (BOB member since 2002-06-25)
Edna,
If you want to convert a foreign currency into dollars (is this Aussie or US?) then you need to use a specific currency rate. As the currency rate changes on a daily basis, your database should include in its design, a currency rate table. This table will need to be utilised at SQL run time to evaluate a date, select the appropriate currency type, date and rate and perform a calculation in order for the currency exchange into dollars to occur. All this can be handled through the design of the structure and objects in the Universe.
Hope this helps, but if you need further info, email me back.
Ang.
Listserv Archives (BOB member since 2002-06-25)
Interesting question,
I recommend a database stragegy (create new columns). Although a DECODE statement used in conjunction with a Currency type and exchange rate will probably be a common suggestion, your big problem will be with reporting “historical” amounts.
i.e if you are reporting Jan 2000 results would you want to see them in $US based on the Jan 20000 exchange rate, or $US based on todays (Apr 2000) exchange rate (there may be BIG differences in the two).
Business Users will invariably want both depending on the situation/report and then you’ll tie yourself into serious knots.
Simon
Listserv Archives (BOB member since 2002-06-25)