How to Build Delta Loading in BPC 7.5 NW
Solution
Prerequisites
You want to extract finance transaction data to BPC, the data source is 0FIGL_10. DSO(0FIGL_O10) has been created. Loading from InfoCube is not recommended because the compression will break the delta request.
All the data has been loaded to DSO-0FIGL_10.
Step by Steps
Setp1
Set up a Staging DSO(Z_FIBPC) with the same dimension as the destination Application.
Setp2
Create Transformation from 0FIGL_O10 to the new DSO(Z_FIBPC).
Setp3
Create DTP to load delta data. Select “Only Get Delta Once” in the Delta Mode.
Setp4
Create Process Chain for data loading.
Use UJD_TEST_PACKAGE to include the Data Package into the Loading process chain.
Great post!
I agree. This is a great post!
If you are ever looking to do this in BPC 10 NW, please take a look at the free content in the SAP rapid-deployment solution for new G/L financial planning.
This RDS integrates BPC to the SAP G/L, leveraging standard BW content! The SAP G/L-based BPC cube and the staging cube are included with the RDS.
You simply restore the BPC cube and the staging layer into your environment, practically eliminating build activity. The transformation and conversion process is set to-go, including master data and delta transaction loads. The RDS takes advantage of new features in BPC 10 NW to enable both full and delta loads.
RDS Name: SAP rapid-deployment solution for new G/L financial planning
https:/service.sap.com/rds-bpcplanningecc
This content is FREE to licensed customers of BPC NW! As of October 1, 2012, the RDS will be upgraded to make HANA an option, amongst other new features.
Hi
Did you set the BPC data packages to Replace&ClearData" or "MergeData"?
Kind regards
Erik
Erik,
This is all done through BW.
Sincerely,
Jason
Yes I got that, but did you set BPC data packages to Replace&ClearData" or "MergeData"?