Transaction data loading from BW info provider using delta initialization package

[former_member193143]

Hello Everyone,

Continuation to previous blog: Master data loading from flat file (http://scn.sap.com/docs/DOC-63482), writing another blog on the same data loading topic, but this is not about loading about flat file. This is about the loading from info provider.

The main purpose of this blog is pulling data into BPC from the rates data which is available in the BW side

Here I am using the delta initialization package to pull the data from BW to BPC.

Assumptions:

1. The data is already available in the BW info provider
2. Dimensions required for rates model are already created, and model is also available in BPC web admin.
3. The connection is already established.

Step 1:  Log on EPM add-in Excel.

Step 2: Create transformation file (please take a look in to how to load master data loading from flat file for how to create transformation file)

  This is sample transformation file

Next click on validate transformation file

Next click on save. We will see validation successful log like below..

Step3:  Create a delta initialization package.

1. Go to Data Manager Tab à organize à organize delta initialization

The below screen will appear when you complete the 3^rd step. Next right click on the screen and click one new.

It will pop up a screen like below and give the respective fields. How to fill those fields are also mention in the below image.

Next go to organize à organize package list à go to data management à add package --> /CPMB/LOAD_DELTA_IP

Add the above package.

Step 4: Running package

1. Next go to run package --> select the package which is created above --> click on run

It will ask for delta initialization file which is created in the step 3

Click on next, it will ask for whether we want run the default logic choose no

Click on next, it will ask whether we want check the work status or not, choose no

Next run and next view status.

Please feel free to add any new points / more points

Regards,

Saida Reddy G