Using exchange rate in summary queries
The data in the cube contains the order amount in order currency and the exchange rate. When the query contains the order number and I multiply the amt in order currency with the exchange rate, each line is correct and when I set the result to summation, the totals are good.
However, when I don't have the order number in my query, the multiplication happens using the summary values of both the order amt and the exchange rate which makes it way off.
Is there a solution? I've tried using the currency conversion but don't know how to set it up so it uses the exchange rate in the document. It doesn't look like currency is being maintained in BW. Not even sure it's being maintained in R/3. How would I check in R/3 to see if it's maintained. And if it's not maintained in R/3 - how do I get started?
Hope someone can help. Lots of data here.