Full load IP & Delta load DTP (BI 7.3)

[saravanan_a]

Hi Experts,

Data flow  of my scenario is source to cube (transactional data).

IP --> full load

Corresponding DTP --> delta load

Data source : 0CO_OM_WBS_7 (WBS Elements: Commitment Line Items)

Here DTP load is functioning as full load & not as delta. So data getting accumulated in the cube after each run, thus resulting in data inconsistency.

I would like to know why DTP delta functionality is not working? Or did I miss something here? Please clarify.

[saravanan_a · Accepted solution]

Thanks All for clarification..

Can we use delta IP & full load DTP in any scenario? Is this possible/recommended?

I want to confirm from you guys..

Regards,

Saravanan.

[anshu_lilhori · Accepted solution]

Hi,

Full DTP will combine all the PSA request into one single request every time.

Suppose your PSA is having 5 requests out of that 4 are already loaded and 5th request needs to be updated then if you run DTP in full mode it will combine all the 5 requests into one request and load to the target.

In case of delta DTP it will only take the request which needs to be updated so in the above scenario it will only load the the 5th request.

If your target is dso and all the keyfigures are in overwrite mode then full DTP will not create a problem,but in case of cube it will keep adding the same so it is not recommendable.

I would advice you to give a try on this on your own system for better understanding and you will register that forever.

Hope that helps.

Regards,

AL

[saravanan_a · Accepted solution]

Thanks Anshu.. I will try in system as suggested.

[RamanKorrapati · Accepted solution]

Hi,

When your data source supporting delta(info pack delta) functionality why don't you go with Delta DTP.

Delta info pack --> Delta DTP SAP Standard

Delta info pack-- full dtp, it leads data in consistency, Because Full dtp it loads all the request which are lied at PSA during the DTP full load.

Thanks