Currency in fact table
3 posters
Page 1 of 1
Currency in fact table
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,
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,
Re: Currency in fact table
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
Re: Currency in fact table
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.
Work with your accounting people to fully understand how the currency conversion (to standard) should be calculated.
Similar topics
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
» Healthcare Hospital Stay fact table - transaction fact table - a row for In and a row for Out?
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
» Healthcare Hospital Stay fact table - transaction fact table - a row for In and a row for Out?
» Design a snapshot Fact table in data mart from compliance-enable fact table in enterprise data warehouse
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum