3357245 - Prerequisites for Saving SAP Analysis for Microsoft Office Workbooks on the SAP Analytics Cloud

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

There is an error when trying to save SAP Analysis for Microsoft Office Workbooks in SAP Analytics Cloud. For example:
-----------------------------------------------------
[742f-6d73-db] Could not upload file. Error: {"message":"","stack":"","errorDetails":[],"status":400,"bUIMsg":false,"bWarning":false}

-----------------------------------------------------

SAP Analytics Cloud 2.0

SAP Analysis for Microsoft Office 2.8

1. Run AO workbooks
2. Click on File -> Analysis -> Save Workbook -> Save a workbook on the SAP Analytics Cloud Platform
3. Save the Workbook in the SAC Repository

Pre-requisite on Analysis for Office side :

• The AO (Analysis for Office) version should be 2.8 SP18 or higher.
• The setting 'EnableSacAsRepository' must be enabled.
• The preferred platform must be either 'Selectable' or 'SAP Analytics Cloud'.

Pre-requisite on SAP Analytics Cloud side : 

• SAC is running on Cloud Foundry.
• SAC Version is 2023.10 (QRC3 2023) or higher.
• Make sure that users are assigned to a role that has the necessary permissions:
     - To create Analysis Workbooks, the role must have the "create" permission enabled.
     - To open existing workbooks, the role must have the "read" permission enabled.

AO, Analysis for Excel, Analysis for Office, A4O, AFO, SAC, folder, Option, Store, LastSelectedSacSystem , KBA , BI-RA-AO-XLA , Excel Addin , How To

SAP Analysis for Microsoft Office 2.8 ; SAP Analytics Cloud 1.0