SAP Knowledge Base Article - Public

3616250 - Long Refresh Time When Changing Filters in SAC Addin Workbook

Symptom

When changing the value of a filter in a SAC Addin Workbook, the refresh process takes approximately 30 seconds to complete.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

.

Environment

SAP Analytics Cloud 1.0.

Reproducing the Issue

  1. Open an Excel Workbook.
  2. Sign-In to our SAC tenant.
  3. Click on the pencil icon for the dimension for which you want to change the value.
  4. Remove selected value.
  5. Select another value.
  6. Click OK.
  7. Wait until the loading process is done and the new value is shown.
  8. It takes around 30 seconds to finish.

Cause

One possible cause is the presence of numerous styles in the workbook. Some issues in Excel cause styles to duplicate multiple times.


Resolution

Please clean up the Excel workbook. 

Keywords

KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud 1.0

Attachments

WBStyles.png