Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
guga
Starting Member
1 Post |
 Posted - 2006-01-31 : 05:58:02
|
| Hi,I am having an fact table with amount stored in different currency. ExchangeRate dimension where the currency rate is stored for each day. I need tobuilt a cube. When the user selects the currency in the exchange ratedimension all the values in fact table should be converted accordingly basedon the rates mentioned in the Exchange Rate Dimension for the payrolldate.Fact table - payroll processing---------------Empid,Payrolldate,accountid,Departmentid,Amount,Currency SymbolDimension Table - Exchange Rate----------------------------Exchange DateSource CurrencyDestination CurrencyRateExchange Rate Dimension---------------------------------------Destination Currency - Rate as the propertyPlease help me in finding a solution.Regards,Regards,guga |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-01-31 : 07:14:42
|
| Hi GugaIt's not advisable to implement something like currency conversion as a dimension table. Assuming that you are storing spot rates each day (Exchange Date), this is almost certainly a fact rather than a dimension with a pair of FKs to a true Currency dimension playing roles as FromCurrency and ToCurrency. I would also suggest a uniform approach to foreign keys within your payroll processing fact table. I.e. stick to surrogate keys for all FKs including Payrolldate and currency. If you've not already looked at Kimball for this kind of thing, I would very much recommend it. The following link has a bit on currency conversion:[url]http://www.intelligententerprise.com/db_area/archives/1998/9812/warehouse.jhtml[/url].Mark |
 |
|
|
|
|
|
How to handle multi currency.