Process Chain Creation using SAP BW 3.5

Process chains are used extensively in SAP Business Warehousing for executing loads, running reports etc. sequentially or parallel.

There can be number of steps with in a process chain. You can also decide what has to be done incase a particular step fails. In case of failure you can decide to sent notification email to concern person who can correct the issue.

In this section we will see how to create a process chain using SAP BW 3.5. Using this process chain we will load data in Infocube.

1) Execute transaction RSPC

2) Press 'Create', enter 'Name' and 'Description' of the process chain, press 'Continue'

3) First step in the process chain will be a 'Start' step,

press 'Create' to create a process variants

4) Enter 'Name' and 'Description' of the process variant

5) 'Save' process variant and go back, 'Change selections' is used to schedule the process chain, we will revisit this again later

6) Press 'Continue'

7) Select the InfoPackage which is used to load data in

Infocube, drag InfoPackage to right panel

8) Select the process variants as InfoPackage using fucntion key F4

9) Select the InfoPackage ZAAA and press 'Continue'

10) Following steps will be added in the process chain

11) Join 'Start' step with step 'Indexes' by selecting 'Start' step and

dragging the line to 'Indexes'

12) Go back to 'Start' step and right click to 'Maintain Variant'

13) Select 'Immediate' to schedule the process chain immediately

14) 'Check' the process chain and 'Activate' the process chain

15) Execute the process chain, enter the server name in the following screen

16) Process chain will start executing, to check the status, Press

17) Select 'Yesterday and Today' to check the status of the process chain

18) Following screen shows that load is still not completed

19) Once completed, the status will appear as follows,

incase there is any failure, the status will appear as cancelled