Skip to Content

Solution

1.JPG

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.

/wp-content/uploads/2012/09/2_137436.jpg

Step by Steps

Setp1

Set up a Staging DSO(Z_FIBPC) with the same dimension as the destination Application.

/wp-content/uploads/2012/09/3_137437.jpg

Setp2

Create Transformation from 0FIGL_O10 to the new DSO(Z_FIBPC).

/wp-content/uploads/2012/09/4_137438.jpg

Setp3

Create DTP to load delta data. Select “Only Get Delta Once” in the Delta Mode.

/wp-content/uploads/2012/09/5_137439.jpg

Setp4

Create Process Chain for data loading.

Use UJD_TEST_PACKAGE to include the Data Package into the Loading process chain.

/wp-content/uploads/2012/09/6_137440.jpg

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Mark P Burke

    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.

    (0) 

Leave a Reply