3627929 - long refresh times for big files containing sap.getdata formulas in sap analytics cloud add-in

• users report extremely long refresh times for big files containing SAP.GETDATA formulas since today. The file used to refresh in less than 3min, now it took forever.
• HAR Summary Time charts show most of time is spent in WAIT - 8011.450 sec
• Reviewing individual calls most follow this pattern with sub .1 second for all (send\blocked\receive...) but WAIT is 30+ sec

SAP Analytics Cloud, add-in for Microsoft Office

1. Open a large Excel file containing SAP.GETDATA formulas.
2. Attempt to refresh the data.
3. Observe the refresh time exceeding the usual duration significantly.

complexity

Users that have large private versions should publish them.

The steps are in the help:

Planning on Public Versions | SAP Help Portal  https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/b6e3d093988e4c3eba7eb6c1c110e954.html

Example:

If a public version is in edit mode, a private version will also be created that allows you modify the data without interfering with the original version until it has been saved and thus, published. This edit mode suggests you work on the public data directly but you're working on a copy, a private version of the data container that is only visible for you. It is called "public edit mode". This kind of private versions created invisible during a public edit mode are known sources for potentially high memory consumption and expensive query processing because of the big amount of data. Whenever a user edits a public version, the whole data in the model is copied into an internal private version since the whole dataset needs to be prepared for potential modification. This is a common root cause for very big private versions.

To avoid this, use planning areas. Please check the following to see if it applies in your scenarios:

help.sap.com - Planning on Public Versions

help.sap.com - Optimize Planning Models Using the Planning Area

Blog - Introduction to the planning area optimization for SAP Analytics Cloud/

Refer to: Clear the add-in cache

Refer to: Use the System Overview

Refer to: SAP Analytics Cloud Administration Cockpit

Refer to: SAP Analytics Cloud Performance Analysis Tool

Refer to: Planning on Public Versions

Refer to: Optimize Planning Models Using the Planning Area

Refer to: Introduction to the planning area optimization for SAP Analytics Cloud

long refresh times, SAP.GETDATA formulas, SAP Analytics Cloud, performance drop, Excel, data refresh, wait time, network time, performance optimization, planning models, private versions , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem