Typical requirement - Help needed!!

32 Views

Dear all,

I have the below requirement. I have 2 keyfigures.

1. Allocated Qty (from APO)

2. Order Qty (From ECC)

I have Allocated Qty in Cube1 and Order Qty in Cube2.

I have built a multiprovider on Cube1 and Cube 2 and my report looks like this.

PLANT*********SHIPTO**********CALMONTH**********ALLOCQTY**********ORDERQTY**********REMAININGQTY

2222***********83747338**********09/2009*************2000******************1000******************1000***********

Remaining Qty = AllocQty - Order Qty

However, I have Sales Document in Cube2. When I drill down Sales Order into the report my report looks like this since I dont have Sales Order in Cube1.

PLANT*********SHIPTO**********CALMONTH***SALESORD*****ALLOCQTY**********ORDERQTY**********REMAININGQTY

2222***********83747338**********09/2009********509388********000000******************1000******************-1000*******

2222***********83747338**********09/2009***********#*************2000******************1000**********************1000*******

But my requirement is even if I pull the Sales Order the report should showthe allocqty like below

PLANT*********SHIPTO**********CALMONTH***SALESORD*****ALLOCQTY**********ORDERQTY**********REMAININGQTY

2222***********83747338**********09/2009********509388********2000******************1000***********************1000*******

Can any one help me how I can achieve this. Is this possible in BEx. I dont want to go with the change to Database option if this can be done in the Query. I have used the Constant selection feature but it adds up all the values.

Any one has a solution to this? If not possible in BEx what is the best way to do it in the backend at the cube level. This is simple example I have put here but my cubes are much more complex than what I have given here.

Any solution would be highly appreciated.