Show TOC

 Displaying BI Query Runtime Statistics on the WebLocate this document in the navigation structure

Use

Using the display for BI query runtime statistics, you can display the technical information relating to the performance of a Web application directly on the Web. Profiling statistics are also displayed. If performance problems occur at runtime for a Web application, you can send this information to SAP in a customer message for error analysis purposes.

You can display the statistics data on the Web by adding parameter &PROFILING=X to the start URL of the Web application. 

Integration

The Web display of performance statistics for Web applications is a fundamental part of BI query runtime statistics. More information: BI Query Runtime Statistics .

Prerequisites

You have executed a Web application as a standalone using a URL.

Features

When you add parameter PROFILING=X to the start URL for the Web application, the dialog for displaying the statistics results appears.

Note

The statistics results are displayed with highly technical and internal information. This information is intended for SAP for performance analysis purposes. We have therefore decided specifically against documenting certain parts of the statistics results.

In the dialog box, the following data is displayed in the corresponding columns:

  • individual steps at runtime for the Web application
  • summary of each step
  • Java events
  • OLAP events
  • data manager events

To navigate to the print view for the statistics results, choose Open Print View. By pressing Download Text File, you can create a file in text form with all information required by SAP for performance analysis purposes.

The summary of each step contains the entire runtime of the step (Step runtime), the ABAP runtime (Remote runtime) and the Java runtime (Local runtime). The individual events are assigned to the relevant context (such as Front End, OLAP, Planning). The context is specified by the handle type. Handle types and corresponding short descriptions for them are in the table RSDDSTATHANDLTP.

The main handle types are as follows:

  • APPL: Runtime in a BI application (workbook, Web Application)
  • BRFC: Runtime of a BEx RFC (function module call with RFC)
  • DFLT: Other runtimes without assignment (Default Handle)
  • DP: Runtime of a data provider in a BEx Web Application
  • F4: Runtime of the input help (F4; flat list, hierarchy nodes)
  • ITEM: Runtime of a BEx Web item in a BEx Web Application
  • OLAP: Runtime in OLAP including runtime of the query
  • PLAN: Runtime of a planning function

In addition to the events from the ABAP runtime (BI query runtime status), the Java events also contain the events from the Java runtime (BI Java). This makes is possible to analyze the runtime in Java. The time data for the Java events is divided into gross and net time. The gross time contains the entire runtime for a step. This is the runtime for the step itself and the runtime for the relevant substeps. The next time contains only the runtime for the step itself, without the substeps.

The OLAP Events column displays the BI query runtime statistics data. The web display thus provides a handy method for analyzing query runtimes.

Data Manager events contain the information from the data manager, from reading the data.