Doubt in Dataflow in BI

[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

which should comes first

[Former Member]

Hi,

1. If the data sources A and B doesnot have any dependency, then you can have your flow as:

start -----> Infopackage for DS A (and) --------->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.

(Info packages A an B can run in a single step, you dont want to wait for A to complete to trigger B)

If you have dependencies in the data source, then execute them pne after another.

2. Generally, the flow in 7.x would be

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

But there are some exceptions, where we will be placing Info sources between PSA and Target to achieve some calculations or data for few fields through routines. Please check that, if everything is direct mapping, then you can go with normal flow. If not you have to place the info source inbetween.

Hope this helps.

[Former Member]

Dear Vijaykumar,

1. The flow that you have suggested, you can use provided that the flows doesn't have dependancy on each other.

2. Create Index will come first

3. I am unclear on this point. Is it 3.x flow. If yes then you have to just trigger infopackage and DTP cannot be triggered to load from infosource to target. Please clarify on this point. If the same flow is which you are going to modify then clear the flow first.

Regards,

Dinesh