How to Build Delta Loading in BPC 7.5 NW

[Former Member]

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.