Data Load from BW to BPC 10.0 Netweaver

[Former Member]

I am using Load Transaction data BW info provider UI to load transaction data from BW cube to BPC cube. In the data manager package there are options in data transfer mode as 

1.    Aggregrate Overwrite

2.    Append

Also  in Load Transaction data from BW Infoprovider UI there are options of

1.    Merge data

2.    Replace and clear data values.

What is the best practice and is there an option of delta load since lot of records are getting created on each load.

Please suggest

Regards,

[ashwin_kulkarni2 · Accepted solution]

Hi Mahesh,

Yes, there is an option of delta load to BPC.

Delta initialization will also be available with a higher enhancement package. When available, you will be able to create delta initializations by going to Organize → Organize Delta Initialization on the Excel “Data Manager” tab. Here, you will then see the existing data initializations and all related information and can create a new delta initialization. It is possible to flag “Trigger a full load at the first run”.
To run the delta initialization, you will then have to execute the relevant package and select the delta initialization you want to run. You run the delta initialization from the Run Package dialog box.

Full upload is supported for Standard Cube, Virtual Cube, Multi-provider, Standard DSO, Write-optimized DSO.
Delta upload is supported for Standard Cube, Standard DSO, Write-optimized DSO.

1. Load Transaction Data from BW InfoProvider – Aggregate Overwrite - Merge
With „Merge“ the system checks if the second load contains selections that were also in the first load and deletes them. Data sets with selections that can‘t be found in the second load are kept. New data sets from the second load are added. In general: Data in the source will first be aggregated by all dimensions. Then data in the target will be overwritten by source data by all dimensions.

2. Load Transaction Data from BW InfoProvider – Aggregate Overwrite – Replace and Clear
Replace and Clear first deletes all data from the first load and then adds data from the second load. In general: The target data will first be cleared by E/C/T/D in the source. Then data in the source will be aggregated by all dimensions and overwrite the target by all dimensions.
Note: Replace and Clear with Aggregate Overwrite and Replace and Clear with Append always deliver the same results.

3. Load Transaction Data from BW InfoProvider – Append - Merge
Merge and Append add the data from the first and second load when selections are the same. If selections are not the same the data sets from first load are kept and those from the second load are added. In general: The source data will be appended into the BPC cube. Key figure will be appended.

4. Load Transaction Data from BW InfoProvider – Append – Replace and Clear
Replace and Clear first deletes all data from the first load and then add the data from the second load. In general: The target data will first be cleared by E/C/T/D in the source. The source data will be appended into the BPC cube. Key figure will be aggregated.
Note: Replace and Clear with Aggregate Overwrite and Replace and Clear with Append always deliver the same results.

Please go through the following links for more info.

1. http://help.sap.com/saphelp_bpc75_nw/helpdata/en/4f/906a428deb4d68b8c2bfa4608a0b1a/content.htm

2. http://help.sap.com/saphelp_bpc75_nw/helpdata/en/4f/906a428deb4d68b8c2bfa4608a0b1a/content.htm

Hope it helps.

- Ashwin.

[Former Member · Accepted solution]

Hi Ashwin,

I tried to create a delta Load. But when I run it, its ending in warning.

/CPMB/MODIFY completed in 0 seconds

/CPMB/SOURCE_DELTA_IP completed in 0 seconds

/CPMB/INFOPROV_DELTA_CONVERT completed in 0 seconds

/CPMB/APPEND_LOAD_DELTA_IP completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

INFOPROV_INIT_NAME = Data

RUNLOGIC = Yes

CHECKLCK = Yes

　

　

[Message]

--------------------------------------------------------------

Task name SOURCE DELTA INFOPROVIDER:

User BASIS run delta load from InfoProvider ZFIGLC10P with selection

<?xml version="1.0" encoding="utf-16"?><Selections><Selection Type="Selection"/><Selection Type="FieldList"><FieldID>0BAL_FLAG</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>ZBPC_ACCT</FieldID><FieldID>ZBPC_CCN</FieldID><FieldID>ZBPC_PCN</FieldID></Selection></Selections>

No records are returned from ZFIGLC10P

Record count: 0

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 0

Skip count: 0

Accept count: 0

Task name APPEND LOAD DELTA INFOPROVIDER:

Submit count: 0

Reject count: 0

model: Planning. Package status: WARNING

Please Suggest.

Thanks.

[ashwin_kulkarni2 · Accepted solution]

Hi,

Is there any data available in ZFIGLC10P DSO? I see only 0 records.

Warning sign does not mean that package is failed, it is just to inform you that some records have been skipped while loading data because mapping is incorrect or no mapping is available for those members.

- Ashwin.

[Former Member · Accepted solution]

Hi Mahesh,

When you validated your transformation file what message did u see?

Regards,

Kalyan.

[Former Member · Accepted solution]

Great Answer ! Tks for this

if i well undestand :

In the case of Agregate et Overwrite, system reduce number of lines in the cube by agregating all similar keys, right ?

Tks ,

Olivia.