Solution : https://service.sap.com/sap/support/notes/1287179 (SAP Service marketplace login required)
Summary :
Users experiencing performance issues in BExAnalyzer due to refreshing all queries in workbooks with multiple or large queries can now utilize the ANA_SINGLEDPREFRESH functionality. This feature improves performance by enabling single query refreshes, avoiding the need to reload all queries upon each refresh action. It requires updating both server and client components. The server side needs implementation of a Support Package (reference: note 1094799) and setting the ANA_SINGLEDPREFRESH property via RS_FRONTED_INIT. On the client side, installation of BI Frontend Patch 600 for SAP Gui 7.10 or higher is necessary. Additionally, workbook settings must be adjusted to allow individual query refreshes.
Key words :
client install bi frontend patch 600, special code-level, strongly recommend implementation, workbook settings dialog, single query refresh, refresh individual queries, single query, individual queries, refresh option, refresh function
Related Notes :
| 1399968 | BExAnalyzer: enhanced refresh menu |
| 1286653 | BEx Analyzer: Performance issues while displaying hierarchy |
| 1260213 | Performance problems during workbook opening in Excel 2007 |
| 1160093 | Prog error/performance problems when using large workbooks |
| 1148328 | NW 7.0 BI add-on front end Support Package 18 & 7.X SP 600 |
| 1101143 | Collective note: BEx Analyzer performance |
| 1094799 | Corrections in the BEx Analyzer server runtime |