CURRENCY EXCHANGE RATES

View previous topic View next topic Go down

CURRENCY EXCHANGE RATES

Post  nthumu88 on Tue Mar 10, 2015 11:48 am

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.

nthumu88

Posts : 10
Join date : 2015-01-26

View user profile

Back to top Go down

Re: CURRENCY EXCHANGE RATES

Post  ngalemmo on Tue Mar 10, 2015 12:07 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: CURRENCY EXCHANGE RATES

Post  nthumu88 on Mon Mar 16, 2015 2:35 pm

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.



nthumu88

Posts : 10
Join date : 2015-01-26

View user profile

Back to top Go down

Re: CURRENCY EXCHANGE RATES

Post  ngalemmo on Tue Mar 17, 2015 11:37 pm

You could. It is also possible there may be accounting rates that are set based on other criteria.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: CURRENCY EXCHANGE RATES

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum