Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

This article is mainly intended to provide the overview of how to use the Program: "/SSA/BWT" through which you can learn to utilize some useful BW Tools.

The Program "/SSA/BWT" provides the following BW Tools:

  • Process Chain Analysis
  • Detailed Request Analysis
  • Aggregate Toolset
  • Infoprovider BPPO Analysis

In this article I will cover how to use the following tools:

  • Process Chain Analysis
  • Detailed Request Analysis

a) Process Chain Analysis:

As the name itself suggests this tool is used to perform the Runtime analysis of the Process Chains. The analysis can be performed not only at Process Chain level but also at the Process Type level.

Process Chain level analysis mainly serves the purpose of comparing the Runtimes of a chain for different days. For example: A Process Chain in your project daily takes 2 hours to get Completed but for the last 2 days the chain is taking 3 hours to get completed. Now you want to check the runtime of this chain over some past period and also want to know because of which process exactly this time difference is occurring. Then you can use this tool as the option which will provide the comparison of Runtimes of different Processes in that chain for different runs.

Note: Other than providing the comparisons of Runtimes, this tool is also very helpful in monitoring the Process Chains in your box, can be related to the way tcode: RSPCM works, showing the status of the Process Chain (Red, Green or Yellow) and opening the Log of the Process Chain from there by clicking on it. Also compared to RSPCM this tool is much more effective and quick.

Process Type level analysis mainly serves the purpose of knowing how regularly a particular Process Type in a Process Chain is failing or the runtime it takes to get Completed.

How to use:

To access this tool Goto SE38 à Type in "/SSA/BWT" as the Program name and click on execute. The list of all the tools that this Program contents are displayed. (List includes the above mentioned four tools)

By default the option 'Process Chain Analysis' is selected. Now click on the execute button. Then you are displayed with the options through which you can select to perform analysis at Process Chain level or Process Type level. (Along with that, the Time Zones used to display the information is also displayed)

Process Chain level:

If you click on the button 'Process Chains' a window Pops up, here you need to provide the Chain-ID and/or the Log-ID and the Start Date/Time and the End Date/Time.

Decide the parameters to enter as per your requirement, suppose your requirement is to check the runtime of a particular process chain for the past one week, then provide the technical name of that chain in the field Chain-ID and the start and end dates as per last one week and click on execute.

Then the logs of the Process Chain for the selected dates are displayed along with the status (Red, Green or Yellow). The logs of the local chains (if any exist in the Process Chain selected) are also displayed (Much more additional information exist which is self explanatory). Now you can have a look at the Runtimes of different logs.

Now if you want to compare the runtime of the processes in the Process Chain for different logs then select all the logs you want to compare by using the Control key and then click on the button 'Compare Runtimes'. Now you can see the runtimes of all the processes in the chain for all the logs and the difference in Runtimes between different logs is also displayed.

Note:

When entering the parameters if you do not provide any Chain-ID and Log-ID then the status (Red, Green or Yellow) of all the Process Chains running in the box is displayed. Now you can use this tool as an alternative of tcode: RSPCM. The Refresh button at the top helps you to refresh the status of the Process Chains. (Refresh rate is very faster when compared to the refresh rate of RSPCM). If you want to go to the Log view of any chain just click on the Log field of that chain.

Also as in RSPSM you do not need to add the Process Chains. But if you want to use this tool for monitoring and you do not want to display all the chains running in the box, as this is a program you can create different variants with different Chains included.

Process Type level:

And from the Process Chain Runtime Analysis screen if you click on the button 'Process types' a window pops up prompting you to enter the values which include Start/End Date/Time, Process Types, Process Variants and select the status(Red, Green or Yellow) of the Process Types to be displayed.

Now consider you want to check a load in Process Chain for the past one week for its status and runtime, then you select loading as the Process Types and into the field Process Variants give the variant of the loading process from the chain, select all the status to be displayed and enter the dates for the past one week and execute. Now you can find the runtime and the status of that loading process and also by clicking on the Log ID which is also displayed you can go to the Log-ID of the chain in which the selected Process type exists.

b) Detailed Request Analysis:

As the name itself suggests this tool is used to perform the detailed analysis of an individual request.

Generally in RSMO you find all the information of the request in the Header, Status and Details tabs. But if you think that the loads for a particular Infopackage is taking more time to get Completed and you want to analyse at which level exactly the load is taking time to get processed whether at transfer rules processing or update rules processing or something else then from RSMO the only information available is the total processing time of the request, in such cases you can use this tool.

How to use:

To access this tool Goto SE38 à Type in "/SSA/BWT" as the Program name and click on execute. The list of all the tools that this Program contents are displayed. (List includes the above mentioned four tools). Select the second option 'Detailed Request Analysis' amd click on execute. In the following screen provide the Request Number to be analysed and click on execute.

Then you have all the information displayed at data package level. Along with the information available in the Header tab of RSMO, you have the following important information:

  • Avg. PSA Read DP runtime
  • Avg. PSA Write DP runtime
  • Avg. Transfer Rule DP runtime
  • Avg. Update Rule DP runtime
  • Avg. Insert DP runtime
  • Min. DP runtime
  • Avg. DP runtime
  • Med. DP runtime
  • Max. DP runtime

By analyzing the values of above parameters you can decide whether you need to improve your update rules, transfer rules or change the data package settings.

Hope you all have found this article informative.

  • No labels