BW process chain status and QlikView tasks
It can be a problem to know when a BW process chain has finished loading data and QlikView can start loading its part. Below is an example of how you can use the BAPI Connector to check the status of a Process chain and start the QlikView load when ready.
BW process chain overview
Process chains are a robust graphical scheduling and monitoring tool to maintain automation, visualization and monitoring of tasks/processes. Typically this is used to update DSOs and InfoCubes.
The connector transports include a Report program named /QTQVC/PROCESS_STATUS.
Two variants of the program should be created for each process chain, to be used in the beginning and at the end of setting the status of the process. The QlikView script has to be updated with a loop to be able to check the status and finally change the status.
Variant 1 of the Report program sets the indicator to ”N” = Not Ready
and
Variant 2 sets the indicator to ”R” = Ready. When calling the report program the status is stored in our table /QTQVC/Status.
In the QlikView script we utilize the BAPI Connector to check when there is an ”R” in the table, then proceed with normal load, and finally set the status to ”F” = Finish when the load is completed. The BAPI Connector calls a function module named /QTQVC/PROCESS_STATUS, which in turn calls the report program /QTQVC/PROCESS_STATUS.
Setup in QlikView
You need to schedule the QlikView task to start when the Process chains normally end.
Script example
Add a loop in the beginning of the script, using the BAPI Connector to check the Status of the Process chain.
The script will leave the loop when status changes to “R” (Ready) and continue with the normal load of BW data.
When that is finished it should set the status to “F” (Finished) to avoid the same data being loaded twice.
Setup in SAP BW system
You need to be skilled in creating Report variants and maintaining Process chains to do the following tasks.
Do the following:
- Create two variants (N and R) of the program /QTQVC/PROCESS_STATUS, for each process chain.
-
In the process chain, add this ABAP program with variant at the start and at the end of the chain. The Task ID has to be unique for each process chain.
