Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

CURRENCY EXCHANGE RATES

2 posters

Go down

CURRENCY EXCHANGE RATES Empty CURRENCY EXCHANGE RATES

Post  nthumu88 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

Back to top Go down

CURRENCY EXCHANGE RATES Empty Re: CURRENCY EXCHANGE RATES

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

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

http://aginity.com

Back to top Go down

CURRENCY EXCHANGE RATES Empty Re: CURRENCY EXCHANGE RATES

Post  nthumu88 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

Back to top Go down

CURRENCY EXCHANGE RATES Empty Re: CURRENCY EXCHANGE RATES

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

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

http://aginity.com

Back to top Go down

CURRENCY EXCHANGE RATES Empty Re: CURRENCY EXCHANGE RATES

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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