Hi,
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?