dbTalk Databases Forums  

Exchange rate

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Exchange rate in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Prasanna
 
Posts: n/a

Default Exchange rate - 04-08-2004 , 07:39 AM






Can any one guide me in implementing Exchange rate
I have sales cube with measures which need to multiply with currrency
conversion factor from Exchangerate cube
My sales cube has countrykey,Timekey

Exchange rate cube has CurrencyKey,Timekey,Countrykey,Convfactor

Each measure in sales cube should multiply with the Convfactor

I am planning to have currency dimension with one level Currency which
will have values USD,EUR,GBP
If user selects USD should multiply with USD convfactor
Can any one tell me best approach

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.