Skip to Content
0
Former Member
Mar 04, 2007 at 10:31 AM

Reg. Bex Query

14 Views

Hi Gurus,

I am devloping a Bex query in using a multiprovider having following chars and key figures. The data is coming from virtual cube, I wanted devlp a query with out modifying the cubes.

Data in the cube, having only one key figure, without changing the cube I want to achieve below mentioned query result.

Plant DEPT Preffered Shipper ActualShipper Quantity

100 1 100 110 500

200 1 200 200 100

100 1 100 100 200

200 1 200 210 100

500 1 100 110 50

In the report we need to split into two more key figures based on Shipper and Preffered Shipper on aggregated level

Plant Dept PrefferedShipper ActualShipper Quantity PreffredShipperQty ActualShipperQty

100 1 100 110 500 700 500

200 1 200 200 100 200 100

500 1 100 110 50 50 50