How to add new process in Process Chain

[former_member374954]

Hi Guys,

I am working on a requirement where I need to extract some data from 0CCA_C11. This cube is getting filled every morning with the Process chain which has a process "Delete overlapping Request'. I need to add the new cube in this Process chain. The new cube should get filled everyday from 0CCA_C11. But in order to successfully run 'Delete overlapping requset ' I also have to delete the data from new cube. HOw and which Processes should I add in this existing PROCESS CHAIN.

Any suggestions please?

Here is a pic of PC.

Regards

Prashant

[former_member586947 · Accepted solution]

Hi Prashant,

    First remove the process chain from schedule.

    As you are deleting only overlapping request from the cube 0CCA_C11, I believe there will be more than one request lying in the cube 0CCA_C11. If so, don't delete the complete content from the new cube. Try to use the same mechanism for loading the new cube as same as 0CCA_C11.

I mean maintain index deletion for the new cube in the index deletion step of 0CCA_C11. Then create a loading step( IP/DTP) for the new cube after the index creation step of 0CCA_C11. Then create delete overlapping step as same how it has been created for 0CCA_C11. Then create index creation step for the new cube.

Regards,

Satya.

[former_member374954 · Accepted solution]

Satya,

Right now the First step in PC is 'Delete Index 0CCA_C11'

                       Second Step is 'Load Data in 0CCA_C11'

                       Third step is (After And) 'Delete Overlapping request from )CCA_C11'

                        Fourth  and last step step is 'Create Index for 0CCA_C11'

In the New PC As per your email steps should be:-

                       First step in PC is 'Delete Index 0CCA_C11' and 'New Cube'

                       Second Step is 'Load Data in 0CCA_C11' and New Cube

                       Third step is (After And) 'Delete Overlapping request from )CCA_C11' and New Cube.

                        Fourth  and last step step is 'Create Index for '0CCA_C11' and New Cube.

Can you please correct if I am missing something? I am giving a pictorial view as well below. Please review and let me know.

Regards

Prashant

[RamanKorrapati · Accepted solution]

Hi,

above design is fine. But " Load data in new cube" wrongly placed.

You need to load data from 0CCA_C11 to new cube in such case how you add new cube dtp at above.

You can add "Load data to new cube after the AND step.

You can see my previous reply's now you can understand.

Thanks

[former_member586947 · Accepted solution]

Hi Prashant,

    Go ahead with above design and include correction suggested by

Regards,

Satya.

[Loed]

Hi,

You need to remove first the process chain from schedule..Just go to EXECUTION tab and click REMOVE FROM SCHEDULE..

You may now edit your process chain..If you want to delete the content of the new cube, use the COMPLETE DELETION OF DATA TARGET CONTENTS process..

Just post here for questions..

Regards,

Loed

[former_member374954]

Thanks Loed,

Do you mind to give me sequence of processes I should add and at what place i should do that?

Regards

Prashant

[RamanKorrapati]

Hi Prashant,

Check with team lead and do it as below.

At right side data flow, Create index process step, here you can add your new cube name as well.

After the AND process step, you can add DTP which can pull data from 0CCA_C11 to new cube.

At delete index step you can add your new cube name as well.

Before deleting index step, you can add deleting overlapping request from new cube.

Like below steps.

Before AND, you can use same data flow. but in delete index, just add new cube name.

AND process -->DTP which loads data to new cube from 0CCA_C11--> Delete overlapping request from 0CCA_C11---->delete overlapping request from new cube--->delete index from 0CCA_C11 and new cube.

When your going to do changes in chain, first remove chain from schedule.Do it at dev and test it.

later move chain to prod.

Thanks

[former_member374954]

Your response confused me even more.

[RamanKorrapati]

Do this way.

AND Process which is exist in your chain---> DTP(which loads data to new cube)--> Delete overlapping request from cube 0CCA_C11--->Delete overlapping request from new cube-->delete index( here you can add new cube name as well)