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 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