Question Re: Process Chain Format in Technology Q&A

Process Chain Format

Former Member — Mon, 12 Aug 2013 08:33:04 GMT

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.

Re: Process Chain Format

Former Member — Mon, 12 Aug 2013 08:41:25 GMT

Check below links. There are many threads on same.

scn.sap.com/thread/758745

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

Regards,

Ganesh

Re: Process Chain Format

former_member182343 — Mon, 12 Aug 2013 08:42:13 GMT

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

Re: Process Chain Format

RamanKorrapati — Mon, 12 Aug 2013 08:49:20 GMT

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-fc91a5fc2719?quicklink=index&overridelayout=true

Hope it helps.

Thanks

Re: Process Chain Format

MGrob — Mon, 12 Aug 2013 13:42:39 GMT

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

Re: Process Chain Format

Former Member — Fri, 23 Aug 2013 08:37:56 GMT

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