Multiple currencies Handling

View previous topic View next topic Go down

Multiple currencies Handling

Post  naren4it on Fri Jul 01, 2011 3:32 pm

Hi

We have Multiple currencies and we need to design our DWH in such a way that user can see his business in his own locale currency and standard currency (USD).

How can i model my DWH to fit multiple currencies please help.


Thanks
$Naren$

naren4it

Posts : 1
Join date : 2009-12-03

View user profile

Back to top Go down

Re: Multiple currencies Handling

Post  LAndrews on Fri Jul 01, 2011 6:32 pm

On your fact table, store measures in both local and standard (USD).

The precalculation will eliminate any performance impact ..... i.e. you won't be calculating on the fly.

e.g.
Date_Key
Local_Currency_Key
Sales_Amount_Local
Sales_Amount_USD

By leaving the local currency key on the fact table, you could always look up additional currency conversion rates if required for special analysis.

LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

View user profile

Back to top Go down

Re: Multiple currencies Handling

Post  ian.coetzer on Mon Jul 04, 2011 1:21 pm

Hi

Currencies are measures themselves since they are used in computations (to multiple with other fact table)
So you could create another fact table called FactCurrencies.

But then you need a new dimension called something like DimCurrency.

So

FactYourFactTable -> DimCurrency -> FactCurrency

this works well if you store your measures in your fact table in the local currency, and then link to the currency dimension to which the specific transactions should be converted - this can then later on in CUBE etc. be used to find the currency fact (measure rate) and multiply that with the transaction amount = which will give you the local or visa versa calculated measure
avatar
ian.coetzer

Posts : 57
Join date : 2010-05-31
Age : 36
Location : South Africa

View user profile

Back to top Go down

Re: Multiple currencies Handling

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