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 .
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