Create a Simple Process Chain in BW4HANA

Business Example
You need to automate your data acquisition processes by using process chains in BW. You
also want to monitor the execution of process chains. In case of an error, you want to use the
available monitors and logs to find the cause.

Note:

This exercise depends on the output of the exercise, Create a DataStore Object (Advanced) (InfoCube-like).

Task 1: Create a Process Chain that will Extract Data from SAP HANA and load it into an ADSO

1. Open the BW Cockpit Fiori Launchpad. Use the Process Chain Editor tile. Create a process chain with description Z Load CC Data to extract data from SAP HANA and load it
into your ADSO ZADSOA.
You can open the BW Cockpit using the URL or from the context menu in SAP HANA Studio or use the transaction /n/UI2/FLP in the GUI.
Process Chains can be maintained in the tile Process Chain Editor. Alternatively, use the RSPC transaction.
a) Start the BW Cockpit Fiori Launchpad using the context menu of your ADSO
ZADSOA and choose Manage the DataStore Object (advanced). .
b) In the BW Cockpit, choose Home.
c) Click on the Process Chain Editor tile and choose Create.
d) In the New Process Chains app, choose Properties.
e) In the Properties of Process Chain UI, enter the description Z Load CC Data and change the InfoArea. Choose OK
f) Remain on the Process Chain Editor tile.

2. Each process chain needs an own Start Process. Use the properties of the Start Process as proposed.
a) In the Start Process icon, choose Show Properties. Use the settings as proposed and choose OK.
b) Remain on the Process Chain Editor tile.

3. Insert the Data Transfer Process from source ZODSVTD01 to target ZADSOA into your process chain.
a) To insert new process into your process chain, press Add Process.
b) In the new process icon, choose Show Properties. Select Process Type: Load
Process and Postprocessing – Execute DTP.
c) Choose Data Transfer Process. → Show Advanced Search and enter your ADSO
ZADSOA. Choose Go. Choose your Data Transfer Process from source ZODSVTD01 to target. Choose OK.

4. Insert a new Data Target Administration – Clean Up DSO Request process into your process chain. Select Activate Requests for all requests.
● Description: Z Activate Requests
● DataStore Object Name: ZADSOA
Save your process chain with the Name ZPC_CC and activate.
a) To insert new process into your process chain, press Add Process.
b) In the new process icon, choose Show Properties. Choose Process Type: Data
Target Administration – Clean Up DSO Request and Description, ZActivate Requests.
c) Press + Add Row, and enter your ADSO ZADSOA. The Clean-Up Action Activate
Requests is set automatically. Mark All Requests and choose OK.
d) Choose Save. Enter the Name: ZPC_CC, OK. Press Activate.
e) Leave the app.

Task 2: Schedule and Monitor the Execution of your Process Chain

1. Open the Process Chains – View latest status app and schedule your process chain ZPC_CC. Did it run successfully?
a) To schedule your process chain, choose the Process Chains – View latest status app.
b) Select your process chain ZPC_CC and press Schedule.
c) Refresh the screen and check whether the Latest Run: Status shows Success.
d) Stay in the app.
2. Monitor the execution of your process chain ZPC_CC.
a) Go to the details of your process chain ZPC_CC run.
b) Check the run time of your steps.
c) Exit the app.
3. Check your advanced DSO ZADSOA in SAP HANA Studio. Can you find a new activated requests?
a) In SAP HANA Studio use the context menu of your advanced DSO ZADSOA and select Manage the DataStore Object (advanced)..
b) Check the requests. Is the latest request activated?
c) Close all tabs.