3644837 - Analysis for Office workbook takes very long to open in BW/4Hana

• The query execution in SAP BW/4HANA completes within 15-30 seconds, but the provision and display of data in Analysis for Office takes approximately 16 minutes.
• The issue occurs regardless of whether an existing workbook or a new workbook is used.
• The "Request result sets" process in the Analysis for Office logs accounts for approximately 15 minutes.

1. Execute a query in SAP BW/4HANA.
2. Observe that the query execution completes within 15-30 seconds.
3. Open the query results in Analysis for Office.
4. Note that the provision and display of data take approximately 15 minutes.

The issue is related to the Analysis for Office client or the communication between the client and the server.

Update the Analysis for Office client to the latest release (e.g., SP27 or the most current version available).

The latest release of Analysis for Office is on the download site. Details are in the help:
AO Help - download current version

• Refer to: Analysis for Office Help Documentation
• Refer to: SAP Note 2129389 - Analysis for Office Trace
• Refer to: KBA 3021428 - Why to check if the issue is reproducible in RSRT transaction
• Refer to: SAP Note 812732 - Service Connection R/3 Support
• Refer to: SAP Note 1718597 - Service connection "SAP NI Connection"
• Refer to: SAP Note 1773689 - How to add logon credentials securely to a case
• Refer to: SAP Note 2281599 - SAP Remote Support Guideline

analysis for office, sap bw/4hana, workbook performance, request result sets, 16 minutes delay, ao trace, client time, rfc time, update ui, excel addin, rsrt transaction, performance issue, troubleshooting steps, sap notes, remote support. , KBA , BI-RA-AO-XLA , Excel Addin , EPM-BPC-NW-XLS , Report on EPM-XLS* , EPM-XLS , EPM Excel Client , Problem