SAP BW: Only load data is insert or update from datasoure to ODS

[former_member597295]

Dear all,

I have datasoure 0REFX_2 from ERP and Data tranfer object (ZDTO_TEST) from BPC is contain,I load data from ERP system to BPC system 10.

the first, I load all record from 0REFX_2 to ZDTO_TEST.

the next, I just load records in 0REFX_2 is new or change.

eg:

               DATA:

                                   objnr          fromdate          todate                         amount

                                   object1      sep,18 2014     march, 18 2015            10

                                   object2      sep,18 2014     march, 18 2015            20

                                   object3      sep,18 2014     march, 10 2015            30

               THE FIRST : LOAD ALL

               CHANGE DATA:

                                   objnr          fromdate          todate                         amount

                                   object1      sep,18 2014     march, 18 2015            10

                                   object2      sep,18 2014     march, 18 2015            25          change amount

                                   object3      sep,18 2014     sep, 18 2015                30          change period

                THE NEXT : I just load object2 and object3

What should I do.

Thanks.

[former_member597295]

I want to do in this document, page 8

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a080ea68-fba2-2e10-8cb7-d42d5bfba...

Thanks.

[Former Member]

Hi Mr. D,

Please look whether below setup would be useful or not.

1) Create Data Source

2) Create Infocube. Use this as staging infoprovider for bpc loading

3) Use either "Append" or " Overwrite records with match key" in Transaction data DM package during data loading into BPC.

Lets assume you wanted to load current month data. Select the required month in "Set Selection" button under infoprovider in DM package. If you want to run for same month with updated records, then select "Overwrite records with match key".

Regards,

Venkat

[former_member597295]

Dear nara,

I do not want Set Selection

I just load Transaction data is change or insert.

Thanks.

[Former Member]

Hi D,

I want to do in this document, page 8..........!

As per your requirement this can't be observed in BPC level it can be observed only in BW Level ...

If you want to see the ORecordmode as mentioned in the Document you mentioned above ..

Goto RSA1 in BW ...

Select Display Data for ZDTO_TEST....

And select Field Output for Selection on the Top ....

There check ORECORDMODE.....

Then you can able to see the changes as mentioned in the document ..... Only if you had already done with your DTP Delta Load.....

Aravind

[Former Member]

Hi D,

your requirement is not clear, can you explain it again?

In your DTP you can change overwrite or append.

maybe try that?

Andy

[former_member597295]

Dear Andy,

I load data from datasouce to Datastore Object and I just load records in datasource is change or records is insert.

Thanks