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.
Well done, Diego! 🙂
Very Good Job
Nice job
why am i not able to open or download those pages even after loggin in ? can you please share pdfs ?
Good Information. Thanks
Hi, I am not able to open obove notes. I would appreciate if any1 helps. Thanks