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
- Open an Excel Workbook.
- Sign-In to our SAC tenant.
- Click on the pencil icon for the dimension for which you want to change the value.
- Remove selected value.
- Select another value.
- Click OK.
- Wait until the loading process is done and the new value is shown.
- 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 |