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

Currency in fact table

3 posters

Go down

Currency in fact table Empty Currency in fact table

Post  John Simon Mon Jun 20, 2011 4:21 am

Hi Guys,
How do you record currency in your fact tables?
Do you (a) convert to a single currency (e.g. USD) as part of the ETL and then convert back to the local currency if required at reporting time, or
(b) keep the original currency and convert at reporting time for comparisons?

Answer (a) seems the most logical to me, but I'd like to get an understand on what you guys do and why.

thanks,

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

http://jsimonbi.wordpress.com

Back to top Go down

Currency in fact table Empty Re: Currency in fact table

Post  rens Mon Jun 20, 2011 5:10 am

I keep both US Currency and Local Currency as two different measures. Keeping one of them (Say USD) and calculating other may not give correct values as currency conversion rate may differ. Yes, you can maintain a daily conversion rate dimension. Still , My vote for maintaining as tow separate measures.

rens

Posts : 3
Join date : 2011-06-20

Back to top Go down

Currency in fact table Empty Re: Currency in fact table

Post  ngalemmo Mon Jun 20, 2011 9:25 am

Maintaining two currencies is common practice. Always store the local currency as well as a 'standard' currency. The standard currency should be whichever is used as the corporate level for consolidations and reporting.

Work with your accounting people to fully understand how the currency conversion (to standard) should be calculated.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Currency in fact table Empty Re: Currency in fact table

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