Technique/SAP BW2011. 5. 10. 19:54

Interrupting the Process chain
YJV Active Contributor Silver: 500-1,499 points
Business Card
Posted on May. 10, 2011 02:36 AM in Enterprise Data Warehousing/Business Warehouse

 
 

 Scenario:

Let’s say there are two Process chains A and B and C.  A and B are the Master chains which extracts the data from different non sap source systems. All our BW chains are dependent on a non sap source system, when the jobs get completed on non sap systems, it’ll send a message to the third party system from where our BW jobs will get triggered an Event based.

Note: Reason why the non sap system sends the message to third party triggering tool is because when ever there is failure in the non sap System; it will not raise an event to kick off the BW chain(s). we have to trigger them manually. To avoid this we use the third party triggering toll to trigger the chains at a time using an Event .

Now C is dependent both on A and B, In other words C has to trigger only after A and B is completed. 

We can achieve this using the Interrupt Process type.                          

For example, if Process chain A got completed and B is still running, then using the Interrupt we can make the Process chain C to wait until both the Chains got completed.

Let’s see step by step.

 Process Chain A and B

image

 Process chain C

Process chain C is dependent on both A and B chains, we use interrupts (A_interrupt, B_interrupt) which will wait till those chains got completed.

image

Now let’s see how interrupt works

A_interrupt: Interrupting the PC C until PC A gets completed.

image

image

Copy the highlighted Event and Parameters

image

Enter the above copied Event and Parameter in the Interrupt Process type like below screen 

image

Activate and schedule all the three process chains.

Note: All the three process chains (A, B, C) get triggers on Event based.

When the process chain C is in Scheduling, you can see the job BI_INTERRUPT_WAIT      in both A and B chains like below screens.

image

Three chains (A , B , C) got triggered by the same Event

<image

 

C will wait for both A and B like below.

image

 

 

 


YJV  Active Contributor Silver: 500-1,499 points is a SAP BI consultant


http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24505%3Futm_source%3Dtwitterfeed%26utm_medium%3Dtwitter%26utm_campaign%3DFeed%253A+SAPNetworkWeblogs+%2528SAP+Network+Weblogs%2529
Posted by AgnesKim