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

Multiple currencies Handling

3 posters

Go down

Multiple currencies Handling Empty Multiple currencies Handling

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

Back to top Go down

Multiple currencies Handling Empty Re: Multiple currencies Handling

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

Back to top Go down

Multiple currencies Handling Empty Re: Multiple currencies Handling

Post  ian.coetzer 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
ian.coetzer
ian.coetzer

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

Back to top Go down

Multiple currencies Handling Empty Re: Multiple currencies Handling

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