Skip to Content
0
Former Member
Jul 22, 2016 at 10:21 AM

Use of BPC Cube with BW cube in a MultiProvider

379 Views

Hello Experts,

I would like to know how will we use a BPC Cube with a BW cube under a MultiProvider.

Basically the BPC cube is added with Cost Center, Time and Key Figures - Order, Sales, Order Profit, Sales Profit, Net Profit, Interest, and so on.

Now in order to have all the above Key Figures in the BPC Cube, we made use of a User Defined Dimension - ZKEYFIGURE and with MVAL property in the Transformation file added these KFs from the respective KFs from BW.

Now in BW, these KFs are present independently as different entities, but in the case of BPC, we have added all of them as members of Dimension.

I would like to know, with the concept of MPR, can we use the BPC cube along with BW cube under a MPR and can we report on this for comparing Actual with Forecast values.

Also, how can I load data from the BPC cube into the BW cube, with my main intension being loading the individual data from BPC Key figure to the BW Key Figures.

I look forward to your expert opinions.

Regards,

Sachin