Solution : https://service.sap.com/sap/support/notes/1157582 (SAP Service marketplace login required)
Summary :
The SAP Note introduces the "package wise read" feature for SAP BW 7.0 SP17 and BIA 7.0 Revision 44, enhancing BI Accelerator functionality. It solves performance issues caused by large query result sets by allowing configurable package sizes for data retrieval. To implement, users modify the "chunk_size" parameter in the TREXIndexServer.ini file via the TREX Administration Tool. Recommended settings and procedural steps ensure the smooth application of the new feature across all BIA landscape blades. It’s crucial to adhere to parameters from SAP Note 1002839 even when using this feature.
Key words :
past huge query result sets, bi requests query result sets, sap netweaver bia accelerator monitor, changed trex configuration file trexindexserver, goto -> trex administration tool, query result sets, trex configuration file, terms bi accelerator, trex administration tool, wrong query results
Related Notes :
| 1308131 | BWA 7.00: High memory if package wise read is used |
| 1231794 | APD: Using the BIA to read InfoProvider data |
| 1159305 | Wrong Data with BIA packagewise read and non-cumulatives |
| 1155479 | BIA 7.00: Revision 44 |
| 1133268 | Package-wise reading from BIA |
| 1018798 | Reading large data volumes from BI accelerator |
| 1002839 | BIA 7.00: Error due to huge resultset of query |