Currency in fact table

View previous topic View next topic Go down

Currency in fact table

Post  John Simon on 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

View user profile http://jsimonbi.wordpress.com

Back to top Go down

Re: Currency in fact table

Post  rens on 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

View user profile

Back to top Go down

Re: Currency in fact table

Post  ngalemmo on 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.
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 in fact table

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