Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Currency Conversion in Webi

Dear All .

     i've a problem in my webi report , the problem is that i'm getting my detailed table from olap connection that was belt on bex query ,

     the customer required to get the Amount in local currency only based on the latest rate for the selection month , i.e if i run the report and choose

     selection date 23/07/2014 , the exchange rate should be the end rate of july and so on .

     what i did is i created a generic datasource on the table  TCURR and created a cube on that datasource , then i crated a bex query on that cube

     and using webi formulas i calculated the exchange rate for the closing rate of the selected month

     but my problem is that when i was trying to multiply amount with that rate , i always get an error on the webi table . even if i merged the two queries      with the currency dimension

     can anyone help me on how to use the calculated rate or if there's any other way to achieve this .

Regards

Former Member
Former Member replied

Thank you all for your response

i've solved the issue by creating a currency conversion type on the BW server , with a fixed time reference (Time Reference from variable ) , i selected the (0P_CSDAT) which is the selection date i used on my query

Regards

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question