Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 02, 2008 at 06:52 PM

    I managed to create a currency conversion type correctly and was able to use it in the query - so all is good!

    Add comment
    10|10000 characters needed characters exceeded