How to Analyze BW Queries in TCODE RSRT

Hi,

Below follows essential SAP notes while analyzing, troubleshooting BW OLAP queries in RSRT.

– Troubleshooting: Query Results Issues:

SAP Note: 1591837 – How to analyze query results

Highlighted Points:

[I] Introduction/Summary

[II] Query Monitor (RSRT)

[II.a] Technical Information & Special Features

[II.b] Execute & Debug

[II.c] Key Figure Definition

[III] Query Simplification

[IV] Comparing Query Result with InfoProvider Data (LISTCUBE)

Check link Transaction RSRT – SAP NetWeaver Business Warehouse – SCN Wiki for more details too.

– Troubleshooting: Query Performance Issues:

SAP Note: 1681396 – Query Performance

Highlighted Points:

[I] Executive Summary

[II] Detailed Analysis

[II.A] Identify Query

[II.B] Run Query in RSRT

[II.C] Detailed Analysis in RSRT

[II.D] Analysis of SQL Statements

[II.E] BWA Access

[III] Optimizing Query Performance

[III.A] Query Design

[III.B] Data Modeling

In case BWA is used then consider to review the following notes for more detail:

–Troubleshooting: BWA Wrong data returned by a query

SAP Note: 1789331 Analyse and correct wrong data returned by query when BWA is used

Highlighted points:

1. Verify if the problem is still reproducible and find out which BWA indexes are involved

2. Note down the cubes that were from the BWA-index

3. Find out how to solve the problem

– Troubleshooting: BWA Query Performance

SAP Note: 1871604 – BWA Troubleshooting: Analyse Poor Query performance

Highlighted points:

1. Check whether the query uses BWA or not

2. Check where most of the runtime is spent

3. Check for any errors using the checkBIA.py python script

4. Check if a reorg is proposed by BWA

5. Check for partitioning of a huge F-Index

6. Review BWA Statistics index

7. Review the Alert server for any errors/warnings

8. Execute a Performance trace

9. Execute Python Trace

Thanks,

Diego Seben.