Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member188743
Active Participant

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.

6 Comments