Analyzing Query Runtime Statistics
You use the report-report interface (RRI) functionality to analyze the time trends of runtimes. RRIs allow seamless navigation from the iViews to the relevant transaction or query. RRIs ensure:
- Minimal effort in administration of BW systems
- Immediate navigation to the transaction or query, optimizing the time taken
- Optimal system performanceNoteNote Most RRIs are common to all iViews, but some RRIs are specific to iViews on specific monitors.
- In the Detailed Navigation pane, under Query Runtime Statistics, choose <BWI Application> Statistics.
- On the <BWI Application> Statistics screen, in the BI System Selection area, select a relevant BW System.NoteNote <Application> is a BW application, a BW applications object, or an InfoProvider.
- In the context menu of the relevant iView, select an RRI.
BW Applications Performance RRIs
The following RRIs are available on all the iViews that can be viewed in the BW applications performance monitor:
Report-Report Interfaces Common to All iViews
| RRI Name | Description |
|---|---|
|
Aggregated Query Runtime Statistics: Analysis |
For the selected BW objects, you can view the key figures (in the last 24 hours) with respect to their time trends, deviations, total time taken to successfully execute a BW object, and the time taken for individual layers. |
|
Detailed Query Runtime Statistics: Analysis |
For the selected BW object, you can view the execution runtime (in the last 24 hours) for queries, the time taken at each step of query execution, and the number of navigation steps in the query execution. |
|
Data Manager Statistics: Analysis |
For the selected BW object, you can view the runtime (in the last 24 hours) details of various events in the data manager. You can also view the number of records selected and transferred from the database. |
|
Manage InfoCube |
Starts InfoProvider Administration for the selected BW application. You can view the details of the InfoCube requests for the InfoCube on which the BW application is built, such as the request ID, request status, number of records transferred, number of records added, and source system. |
|
Display InfoCube |
Opens the Display <BWI object> page for the selected BW application. You can edit the <BW object> on which the BW application is built as well as the <BW object> structure. For example, you can edit the dimensions, key figures, and attributes for the InfoCube. |
|
Change InfoCube |
Starts the Edit <BWI object> page for the selected BW application. You can view the <BW object> on which the BW application is built as well as the <BW object> structure. For example, you can view the dimensions, key figures, and attributes for the <BW object>. |
|
Object Overview |
Opens the Object Overview page for the selected BW object. You can view the key figures, time characteristics, and characteristics for the InfoCube on which the BW object is built. |
|
Data Flow |
Opens the Display Dataflow page of the InfoProvider on which the selected BW application is built. You can view the data flow diagram on this page. |
The following additional RRIs are available on the Runtimes and Deviations in Runtimes iViews for the Query Runtime Statistics Monitor:
Additional Report-to-Report Interfaces for Runtimes and Deviations in Runtimes
| RRI Name | Description |
|---|---|
|
Long-Term Trends for BW Application Object Durations |
For the selected BW application objects, you can view the runtimes of successful executions during the last 30 days. |
|
Short-Term Trends for BW Application Object Durations |
For the selected BW application objects, you can view the runtimes of successful executions during the last 24 hours. |
|
Missing Aggregate Report for Queries |
You can view the BW application objects that adversely affect system performance. This includes the:
|