"Only Get Delta Once" - How to use this correctly?

[Former Member]

Hi folks,

we are currently facing the following situation:

We have a data source only being able to deliver full update.

That's why we proceed as follows:

1.) Full-Load with Infopackage to PSA

2.) Delta-Load with DTP from PSA to first-level-DSO (write-optimized)

3.) Delta-Load with DTP from first-level-DSO to second-level-DSO (standard-DSO). As the activation aggregates all duplicate entries, we are therefore able to deliver a delta to all following data targets (e.g. infocubes)

What we are now wondering about how to use the flag "Only Get Delta Once" which is available in all Delta-DTPs. The help explains it should be used when creating snapshot-scenarios like ours as each request is only delivered once, even if it gets deleted in the data target.

But what other benefit would we have when setting this flag? As I mentioned, the snapshot-scenario also works without this flag...

Could anyone perhaps provide me some more details about this flag and where it should be used?

Thanks & regards

bivision

[former_member223744 · Accepted solution]

Hi, please check the following link which explains this matter.

[Creating Data Transfer Process|http://help.sap.com/saphelp_nw70/helpdata/EN/42/fa50e40f501a77e10000000a422035/frameset.htm]

Thanks,

Walter Oliveira.

[Former Member · Accepted solution]

Hi. Thanks a lot for your answers. Now, the behaviour is more clear for me as I didn't get the real use-case-glimpse while jumping thorugh SAP-docu. I will award points for your answers.

[Former Member]

Say I have request 640,641 and 642 in my infocube then

i have  640,641,642,643 in my PSA.

If there get delta only once option then what data will be present in my IC?

1. Do I need to delete old requests in IC before loading the 643 request.

2. Will only 643 come in my IC?

Also if in PSA 644 request comes then what will be the scenario?

[ram_pandey]

Hi,

If you select the option 'Only get delta once', then every request in the PSA will only be loaded into the Data target once. For example. If you load a full request into the PSA through an InfoPackage and then load it to the Cube. In a snapshot scenario, when the new full load comes to the PSA you will need to delete the previous request from the cube before loading the new request.

But if you delete the previous request from the cube, and not from the PSA - and if you haven't checked the 'Only get delta once' flag, when you execute the DTP, it will load both previous and the new requests from the PSA to the cube. In order to avoid this you have 2 options:

1. You can delete a request from the PSA after every successful load into the Cube OR

2. You can check the 'Only get delta once' flag in the DTP so that it won't load any request it has loaded into the cubes previously even if it was deleted from the cube.

Using the second option de-couples the PSA maintenance from your regular data loading and also saves you an additional step of deleting the PSA request in your process chain.

[Former Member]

Hi,

Plz check the below blog:

/people/community.user/blog/2007/06/21/sap-netweaver-70-bi-data-transfer-process-with-147only-get-delta-once148

May be its useful