Skip to Content
Author's profile photo Saida Reddy Gogireddy

Transaction data loading from BW info provider using delta initialization package

Hello Everyone,

Continuation to previous blog: Master data loading from flat file (, 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.


  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 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 3rd 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


Saida Reddy G

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raf Boudewijns
      Raf Boudewijns

      your last screen shot seems to be wrong: you highlighted /CPMB/LOAD_INFOPROV_UI instead of /CPMB/LOAD_DELTA_IP