Analyzing the performance of SAP Analytics Cloud stories requires the analysis of different components: SAP Analytics Cloud story performance, possible network delays and of course the SAP BW queries in case of a live connection.
But sometimes a constellation with a specific story and the used BW queries needs to be analyzed and you would like to analyze the BW performance on a granular level as in the RSRT query monitor. That’s what this blog post is about: analyze query runtime in SAP BW in the following three steps.
1. Record story execution requests
First, we need to record a trace of the requests sent from SAP Analytics Cloud to SAP BW. This can be achieved quite easily using the Google Chrome or Edge Chromium developer tools. The procedure is described in SAP KBA 2280022 . The result is a HTTP archive (HAR) file that contains all the requests sent to the InA interface in SAP BW.
You will also find an approach using Fiddler, but from my experience using the developer tools of the browser worked just fine.
2. Import and trace requests
To analyze the trace, we now log into SAP BW and open the InA Test Monitor (transaction RSBITT):
The InA Test Monitor can be used to analyze and execute requests sent to the InA interface and create RSTT traces for further analysis. Both with your own user and with other users, just like the “Execute BW query as” function found in transaction RSECADMIN/RSUDO.
This can be selected in the options by unchecking the options “Use SSO” and “Current user”.
Now the HAR file needs to be imported into the monitor:
The monitor will now analyze the contents of the HAR file in a tree structure to allow the analysis of the requests:
Here you can also see all the filters/selections that are sent to SAP BW. But I wanted to show how to analyze the performance and for this we need to activate tracing:
Now we are all set to execute the requests and we can do this either step by step or by running the whole sequence of requests:
I suggest running the whole sequence because with this you can already “feel” how long it takes SAP BW to process the requests. Once the requests have been processed, the Trace ID is available, and we can go on to step 3:
3. Analyze BW query execution
The last step is to go to the RS Trace Tool (transaction RSTT) and analyze the query execution with the known options like “Display Statistics Data”:
Using the InA Test Monitor allows you to analyze the response time of the requests that are sent to SAP BW from SAP Analytics Cloud and identify the reasons for performance issues. Unfortunately, it does not (yet?) provide an automated solution 😉