Solution : https://service.sap.com/sap/support/notes/590370 (SAP Service marketplace login required)
Summary :
This SAP Note details performance issues within infocubes caused primarily by excessive uncompressed requests in F facttables and a high number of partitions. These issues manifest as long execution times during statistics updates, index rebuilds, and during aggregate builds, potentially arousing ORA 14400 errors during data loading. The partitioning mechanism detailed explains each uncompressed request corresponds to a new partition in the F facttable, substantially increasing database objects, thereby affecting performance. Recommended solutions include regular compression of infocubes to reduce the number of partitions and maintain system performance. Future tools in next BW releases aim at improving partition management efficiency.
Key words :
facttable aggregates indexes statistics long execution compression ora 14400 performance, infocubes e-facttable numerous questions, index drop/recreate situations happen, drop/recreate secondary indexes, dropping/recreating secondary indexes, secondary local bitmap index partitions, unacceptable query response times, long execution times, table partition related question, p-dimension partitioning key
Related Notes :
| 1548125 | Interesting facts about Inventory Cubes |
| 1500459 | Analysis of facttable partitions on basis Infocube (ORA DB) |
| 1461926 | FAQ: BW report SAP_INFOCUBE_DESIGNS |
| 1388570 | BW Change Run |
| 1335666 | Selective deletion on ORA F table with too many partitions |
| 1273778 | Currency conversion from SSK into Euro in SAP BW |
| 1178655 | E2E Diagnostics - BI InfoCube compression - information |
| 1013912 | FAQ: Oracle BW performance |
| 903886 | Hierarchy and attribute change run |
| 790223 | DBIF_RSQL_INVALID_RSQL when filling aggregates |
| 779123 | Memory-related terminations at runtime |
| 778709 | Rollup of aggregates and indexes (2) |
| 640464 | Termn rlgmnt run: RSDU_TABLE_COPY_INI/DDIF_TABL_ACTIVAT |
| 588668 | FAQ: Database statistics |
| 407260 | FAQs: Compression of InfoCubes |
| 385163 | Partitioning on ORACLE since BW 2.0 |
| 314719 | BW2.0 ORACLE FEATURES |