I have a DSO where the data is getting loaded from R/3 say DSO1. And for theDSO2 the data is coming from DSO1. Then i have a cube where the source is DSO2. The data which is coming from r/3 have data i.e amount in different currencies. I want to convert that data into a single currency ie YUSD.
My question is can we do currency transaltion at the first DSO. If not then, can we do it second DSO? If yes, then how, by a routine or can be done thru any function module? If yes, then which is the function module which supports currency translation?
We can also do currency translation at the cube level by using currency translation type. But will it be the same as the one which can be done at DSO level thru routine or function module?
We have done the currency translation at the query level, but we require at the Multiprovider level itself.
Can anyone please provide some inputs?
Goto -> RSCUR
Enter the Conversion type as Z_____
Then in Exchange rate tab ->Select the Exchange Rate type as maintained in R3
then in Currncy tab choose the target curency that u want
then in Time Ref tab choose Variable Time Refervnce select the
period that u want to take (begin or end ..) for 0FISCPER
Then save the settings
Now i dont think u require any routine for conversion anymore
Try with this, then ask if any further queries