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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
19 | |
14 | |
11 | |
10 | |
9 | |
8 | |
7 | |
7 | |
7 | |
5 |