Automate data load from BPC cube to BW cube

[Former Member]

Hi Gurus,

I've got all my budgeting & forecasting data in BPC cube. Now I need to load it to a BW cube and combine with Actuals in another BW cube through Multiprovider and build reports on the multiprovider.

My question is:

What is the best way to automate the loading process of BPC cube data to BW cube ??

I should also be able to load the property values of BPC dimensions to the BW info objects.

The methods I followed are:

1. Run "Export" data package and load BPC data to a CSV file and run BW DTP/infopackage to process the CSV file into BW cube. Problem with this is - I canot automate these two steps, and even if I did, I cannot export property values to a flat file.

2. Build transformations directly from BPC cube to an Infosource and from Infosource to BW cube. Problem with this is - in the transformations I cannot use the rule: "Read Master Data". I may have to write a routine, but my ABAP is not good enuf.

Please help with an alternative solution

Thanks,

Venkat

[Former Member · Accepted solution]

Hi,

I am afraid,you will not be able to use BW transformations since no data is stored in virtual info-provider ( assuming you are on BPC for NW ver.7.5); if you are on BPC for NW 7.0 then BW transormations anyway, are of no use, since after light optimization the tech name changes.

As a work-around, I am using APD --> creating a BEx query on virtual info-provider ( since I am on 7.5), using APD and storing plan data in a DSO. Then use this DSO and cube in a m/prov to report Plan Vs Actual.

Thanks

[Former Member · Accepted solution]

Thanks for the reply. I know I will have more options if I'm BPC 7.5 NW. But I'm on BPC 7.0 NW.

I managed to pull the attribute values of BPC dimensions using routines. But still it's risky because the tech names of BPC objects may change if one modifies the dimensions or run optimization.

It's a shame SAP haven't provided a robust solution to load BPC cube data to BW cube data.

I don't want to load BW cube data to BPC cube and depend on EVDRE reports for my 'Plan vs Actual' reports. I (and end users) always want to lean towards BEx reports.

[Former Member · Accepted solution]

@Venkat....you can still build your reports of the multiproviders created by bpc in backend as tehir name doesnt change.

Edited by: Vinay Madhadi on Nov 29, 2011 5:42 PM

[Former Member · Accepted solution]

Hi,

You can use retraction badi to retract the data form BPC cube to another Z object realtime infocube and put both of them into a multiprovider and report on it. Retraction can be automated through datamanager package.

Cheers,

Rammi