Hello Taner,
The best way comes along as per the business requirement.
For e.g.1, If you have a requirement that you are converting all the source document currencies (such as USD, INR, BRL etc) into a single currency (e.g. EUR), then the better way to do that is in direction to DSO. Firstly, as per standard architecture (such as LSA), there should not be any transformation done while loading the data from DSO to cube. In addition to that, if you have huge amount of data coming in, then it is easy for the same to do the translation in DSO layer rather than at reporting layer since it could degrade the performance of the query at run time. But this scenario is when you do not have more than one conversion type in Query.
E.g. 2, If you have to convert the currencies in more than one conversion type such as ROFO, AOP, etc., then you have to go with Currency conversion in the query during run time. There is a t code RSCUR where all your conversion types are maintained. In query designer you can select any conversion type which is present in the RSCUR t code, the currency translation would happen as per the chosen conversion type. But there is one more way out, that prepare different key figures for different currency types and do the conversion in direction to DSO differently for each type of Key Figure.
E.g. 3, The scenario where Currency conversion in the query is via formula, is not very famous when it comes to currency conversion, since you can use the conversion types generally to achieve that and also it may lead to degrade the query performance. So, it may not be used as in general. But there may be a different requirement which could only be implemented through a formula, then in this case it is useful. If not, use Calculated key figures.
Regards,
Sagar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.