Doubt in Process chain flow

[Former Member]

1.I have one doubt that

my Existing Proces chain flow goes this way....

Two Datasources A & B connected to one infocube C

start -----> Infopackage for DS A --------->Infopackage for DS B ---------> Delete Index for Cube C ---------> Execute DTP for DS A---------> Create Index Cube C --------> Compress Cube C ----------> Delete Index for Cube C ---------> Execute DTP for DS B---------> Create Index Cube C --------> Compress Cube C.

This flow comes in Straight not in branches,

My Suggested flow is

start -----> Infopackage for DS A --------->Infopackage for DS B ---------> Delete Index for Cube C ---------> Execute DTP for DS A--------->  Execute DTP for DS B---------> Create Index Cube C --------> Compress Cube C.

Please guide me if i am going wrong.

2. Which comes first? Compression or Creating Index.

3. Existing Data flow from Datasource to cube flows in this way

Datasource -------> Transformation---------> Infosource--------> Transformation----------> Cube

My Suggested flow is

Datasource -------> Transformation----------> Cube

Please suggest me If i am going wrong as it is very important to me.

Thanks in Advance

[Former Member · Accepted solution]

Hi Vijayakumar

Your suggested flow seems correct.

This will also reduce the process chain runtime. More efficient.

Regards

Murthy

[former_member186445]

VIJAYAKUMAR M & Anand Tiragati ..

are you colleagues  or best friends or what?

[former_member210724]

Hi,

1.You can go with suggested flow(2nd)

2. First index and then compression.

3. Go with .Datasource -------> Transformation----------> Cube.

[former_member186445]

1. new flow seems ok

2. first create index then compress

http://www.erphowtos.com/guides-a-tutorials/doc_view/956-how-to-use-process-chains-in-sap-bw.html

3 .if the infosource is not needed (just 3.x remain) you can omit.

M.