Skip to Content

How to include RSRV tasks in process chains

Applies to:

SAP NetWeaver Business Warehouse (formerly BI). This will also work on SAP BI 3.5 and BI 7.0.

Summary :

This document will help us with the steps for adding RSRV tasks in Process Chain

Author: Swapnil G. Thakare

Company: Accenture Services Pvt. Ltd.

Created on:  29 March, 2013

Author Bio:

Swapnil G. Thakare is a SAP BI Consultant currently working with Accenture Services Private Limited. He has over five and half years of experience in various BW/BI implementation and support projects.

Procedure:

RSRV is a tool where we can carry out various maintenance activities related to Master Data, Transactional Data, Cubes, DSO’s, PSA Tables, etc.

Most of the times these activities are part of our monthly/weekly schedules and needs to be performed periodically. But selecting the tools / tasks each time and then executing them and waiting for the result to come can be tedious and time consuming.

To overcome this, we will see that this document will help us to schedule the RSRV tasks through a process chain which can be executed any moment of time or can be scheduled for a later date and can execute any RSRV checks / tasks without any manual intervention.

Just to Begin, I will show you any random check for e.g.: Let’s take “SID Values in X and Y Tables”

Open T-code RSRV, Go to Test in Transaction RSRV à All Elementary test à Master Data à SID Values in X and Y Tables

1.JPG

Here for example I will select one Characteristic and one Cube (Since we have 2 tasks in the right pane)

Since we selected the 2nd option as a Cube, all the characteristics from the Cube are listed below.

Now we are done with the selections for the checks.

Just assuming that these selections are the ones you need to perform checks every month so that we can save it as a package to refer it through the process chain.

Go to Edit –> Test Package –> Save

Give the Technical name and description

Click on Execute and you will get a message as below.


Now our package is ready to be used in process chain. Now let’s create a process chain and use this package.

Open T-code RSPC and create a process chain. Give technical name and Description for the process chain.

8.JPG

Once you double click on program, you get a popup asking for the program. Click on the create button in order to create a new program

11.JPG

Give a Variant Name and click on Create

Next screen will ask for the package ID we created in T-code RSRV .

Click on possible selections inside Package ID to get the list of all the existing Packages

Select the package ID we created “SID_CHECKS”.

Level of Detail can be of your choice (Default is Level 2 but I will select as Level 3).

Cancellation of Process Chain from Selected Message Type should be selected as “E Error” so that the process chain terminates when an error occurs.

Now Click on Back. A popup appears to ask whether we need to save the changes. Select Yes.

Enter the description in the next screen.

Save the changes and go back.


Click Continue on the Insert ABAP Program Popup we had earlier.


Go to Check view and see if everything is ok and then activate and start the process chain immediately or you can schedule for a later date.

Once it’s started, you can see that the ABAP process running.        

While the process chain is running, you can also see the job running in SM37 where you can see the detailed log of the steps being carried out.


Next time we can just schedule the process chain and perform the activity without any manual intervention. Accordingly you can include any RSRV task for similar automation.          

2 Comments
You must be Logged on to comment or reply to a post.
  • Hi Swapnil,

         A great document indeed and thanks for detailing it.

    My only doubt would be to know of a scenario where you'd want to carry out such tests as scheduled tasks. Once the process chain completes and if some of the checks have failed, is there a way the user can know it..? Will the process chain terminate when the tests fail so that the user can then login to RSRV and correct the errors ? Please clarify and thank you in anticipation..

    Regards,

      Manohar. D