Solution : https://service.sap.com/sap/support/notes/1681396 (SAP Service marketplace login required)
Summary :
This SAP note provides guidelines for analyzing performance issues of BW queries from an OLAP Technology perspective, primarily using transaction RSRT. It emphasizes identifying slow queries through frontend tools like BEx web templates, BEx Analyzer workbooks, and reports from SAP Business Objects (e.g., Webi, Crystal, Dashboard). Detailed steps include running these queries in RSRT with the same filters and checking runtimes. It contains sections: Executive Summary, Detailed Analysis with sub-categories focusing on query identification, RSRT execution, SQL analysis, and performance optimization strategies in query design, and data modeling. The note also suggests maintaining updated database statistics, indexes, and considering physical and semantic partitioning.
Key words :
performance problems 1175996 oracle 10g/11g patches check 1171650 automated oracle db parameter check 728017 multiprovider processing - exclusion, components bw-bex-ot-olap analyzing data priority recommendations / additional info category consulting validity, 4 1175996 oracle 10g/11g patches check 1171650 automated oracle db parameter check 1151957 interesting facts, oracle bw performance 948158 performance problems/measuring bi java web runtime 822302 olap cache, bad query performance 948158 performance problems/measuring bi java web runtime 822302 olap cache, 948158 performance problems/measuring bi java web runtime1083462 statistics workbook, execute&debug' -> 'dispaly sql/bia query'&'display run schedule', unit conversions access type 'master data' special key figures, customer component bw-bex-ot olap technology, sm50->menu->program/session->program->debugger
Related Notes :
| 1591837 | How to analyze query results |
| 1548125 | Interesting facts about Inventory Cubes |
| 1475193 | Warnings in transaction RSRT -> Technical Info |
| 1381821 | Memory and Performance Analysis for MDX |
| 1318214 | BWA 7.00: Suspicion of bad query performance |
| 1247763 | BW query: No more hints as of ORACLE 10.2.0.4 |
| 1175996 | Oracle 10g/11g patches check |
| 1171650 | Automated Oracle DB parameter check |
| 1151957 | Interesting facts about the OLAP Processor/Analytic Engine |
| 1083462 | Statistics workbook for performance problems |
| 1025307 | Composite note for BW 7.00 / BW 7.01 performance: Reporting |
| 1018798 | Reading large data volumes from BI accelerator |
| 1013912 | FAQ: Oracle BW performance |
| 948158 | Performance problems/measuring BI Java Web runtime |
| 822302 | OLAP CACHE for remote providers |
| 728017 | Multiprovider processing - exclusion of part providers |
| 590370 | Too many uncompressed request (f table partitions) |
| 514907 | Processing complex queries (data mart, and so on) |
| 402469 | Additional indexes on Master Data Tables |
| 129252 | Oracle DB Statistics for BW Tables |