Process Chain Format

[Former Member]

Hi All,

Please can someone assist with the correct format of my process chain.

I am loading my actuals data as a delta from 0CO_OM_CCA_9   and my budget data from 0CO_OM_CCA_1  as a full load

into

0CCA_C11.

When my process chain runs, I need to delete my previous full load of 0CO_OM_CCA_1  from 0CCA_C11 without deleting the data loaded from

0CO_OM_CCA_9.

I need to do this to prevent duplicate budget data loading.

Please could someone assist as to how this should be done, as I seem to be loading my budgets as a full load every time without deleting the previous loads

Any assistance would be greatly appreciated.

[former_member182343 · Accepted solution]

Hi,

Use Process Type Delete Overlapping Requests From Infocube.

- While creating Variant you need to provide the Infopackage Respective to  Datasource (0CO_OM_CCA_1) name . It makes to delete Request related to datasource 0CO_OM_CCA_1 only.

Regards,

Vijay

[Former Member]

Hi

Thank you all for your responses.

How does this work with compression on my cube though?

What I have done is create process chain A:

This loads my data from my DSO O10 - actuals - and then compresses the load.

Process chain B

Loads my Cost centre accounting, then deletes overlapping requests, then DTPS it up to the 0FIGL_C10 cube...

Will I still now end up in duplicates in my C10 Cube.

Please see images attached.

Process Chain A

Process Chain B

[MGrob]

Hi

You can delete overlapping requests from sames datasource as Ram mentioned in your process chain you find this under "load process and potsprocessing" "delete overlapping request from infocube" or I recommend splitting the loads into two dso one for actuals and one for budgets. You get more flexibility and its faster.

hope it helps

Martin

[RamanKorrapati]

Hi Catherine,

You can use delete overlapping request process step and choose option as when same data source.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0431c48-5ba4-2c10-eab6-fc91a5fc2...

Hope it helps.

Thanks

[Former Member]

Check below links. There are many threads on same.

scn.sap.com/thread/758745

http://scn.sap.com/thread/1019577

Regards,

Ganesh