Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using exchange rate in summary queries

Hi,

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.

Suzanne

Not what you were looking for? View more on this topic or Ask a question