This website is not affiliated with, sponsored by, or approved by SAP AG.

Bex query with wrong aggregation

Business Warehouse

Moderators: Snowy, thx4allthefish

Bex query with wrong aggregation

Postby ax80 » Fri Mar 31, 2017 3:54 am

Hi all,
I have this problem.

I'm trying to do a query in a multiprovider with 2 infocubes, one with data in local currency and another one with currency exchange rates (FX).
My request is to report data in a single currency (i.e. EUR) and let query do the calculation starting from data in local currency from USD, EUR, GBP, YEN..).

The problem I have is related to local currency display in row, I don't want it to be evident (i.e. I just want the total cost for a project, I don't care what is the original list of local currencies).
Below an example of how it works now for me:
Local currency Amount
USD 100
EUR 200
Total: no sense

Exchange rate
USD vs. EUR 1,08

Reporting currency Amount
USD 108
EUR 200
Total: 308

Result is good but local currency is displaied; this how it works for me if I delete the local currency from display:
Local currency Amount
Total: 300

Exchange rate
USD vs. EUR 1,08

Reporting currency Amount
Total: 324

Result is wrong.

Please help on that!!
Ciao
ax80
 
Posts: 13
Joined: Wed May 10, 2006 11:03 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 6 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.