CURRENCY EXCHANGE RATES
2 posters
Page 1 of 1
CURRENCY EXCHANGE RATES
Hi I am designing a star schema and i am stuck with currency exchange rates.
Business need reporting in local currency and standard currency. local currency if the company and business unit is in Canada.
Now what i am doing i am converting currency from local to USD during ETL process. But my manager needs currency dimension and currency exchange rate Fact. What i am not getting is if we are already converting and storing both LOCAL and STANDARD currency in FACT table why we need currency dimension.
This question may be naive.
Business need reporting in local currency and standard currency. local currency if the company and business unit is in Canada.
Now what i am doing i am converting currency from local to USD during ETL process. But my manager needs currency dimension and currency exchange rate Fact. What i am not getting is if we are already converting and storing both LOCAL and STANDARD currency in FACT table why we need currency dimension.
This question may be naive.
nthumu88- Posts : 10
Join date : 2015-01-26
Re: CURRENCY EXCHANGE RATES
It helps to know what the currency is, particularly if the company eventually expands to other countries. Using location to determine what the local currency is is clumsy and prone to error. It is not an issue with the standard currency.
Re: CURRENCY EXCHANGE RATES
Hi ,
Can i maintain two tables for currency exchange rates .
1. one for daily currency exchange rate
2. another for last day of the month exchange rate.
Can i maintain two tables for currency exchange rates .
1. one for daily currency exchange rate
2. another for last day of the month exchange rate.
nthumu88- Posts : 10
Join date : 2015-01-26
Re: CURRENCY EXCHANGE RATES
You could. It is also possible there may be accounting rates that are set based on other criteria.
Similar topics
» Multiple currency exchange rates in fact table
» Measures to be revalued for change in currency rates
» Clients, Roles and Rates
» How to represent survival rates in a fact table?
» Are "INTEREST RATES" fact or dimension attributes?
» Measures to be revalued for change in currency rates
» Clients, Roles and Rates
» How to represent survival rates in a fact table?
» Are "INTEREST RATES" fact or dimension attributes?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum