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

Introduction

When using the query runtime statistics, you can determine how much time the execution of a certain query or a certain navigation step take in the front end and in the analytic manager. Basically, the statistics records can be analyzed by using the technical content(TCT), the transaction RSRT(AdHoc Analysis) or two table views. In particular when you want to analyze a performance problem concerning a certain query, transaction RSRT offers the most convenient way to take a look at the query runtime statistics. See also Query Performance.

Since query runtime statistics generate a very large amount of statistics data, it is recommended to activate this feature only for queries where it is really required. In addition, normally it is also necessary to delete statistics data on a regular basis.

SAP Online Documentation

BEx Query Runtime Statistics

How to activate the statistics for a certain query (transaction RSDDSTAT) 

In transaction RSDDSTAT for maintaining statistics properties, you can activate and deactivate the statistics for certain queries and also e.g. specify the required granularity for each object.

SAP Online Documentation

Configuring Statistics Properties

Changing the setting for a certain query:

Canging the default:

How to analyze the statistics

Checking Table Views

The statistics data is stored in various tables. In terms of analyzing the statistcs data, it is convenient to use the following two views:                                                       

  • View RSDDSTAT_OLAP contains the data from the events in the areas for the front end and calculation layer in the analytic manager
  • View RSDDSTAT_DM contains the event data from the area for the aggregation layer and DataManager
SAP Online Documentation

Analysis Using Technical BI Content for BW Statistics                                                               

Technical BI Content provides predefined BW objects like Cubes(e.g. 0TCT_C01 and 0TCT_C02), queries and web templates for analyzing most statistics data. Before using technical BI Content, you have to activate it. For more information see

SAP Online Documentation

Ad Hoc Analysis of Query Runtime Statistics in the Query Monitor (Transaction RSRT)

Using the feature 'Display Statistics Data' in RSRT, you can perform an ad hoc analysis at query runtime.

The data for the area for the calculation layer of the analytic engine and the data for the area for the aggregation layer are displayed on two separate tab pages. For details see RSRT: Display Statistics Data.

How to delete Statistics Recordings

Since query runtime statistics generate a very large amount of statistics data, it might be necessary to delete the data from the RSSDDSTAT* tables on a regular basis. When using technical content, deletion of statistics recording for query runtime statistics is automated. For more information see Maintenance of Statistics Properties.                                                               

  • No labels