Solution : https://service.sap.com/sap/support/notes/1681396 (SAP Service marketplace login required)
Key words :
performance, web template, Analyzer, workbook,time-out, BICS, MDX, BWA, BIA, SQL, TIME_OUT, slow
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 |