SAP Knowledge Base Article - Public

3352689 - Using SAP Analytics Cloud as repository in Analysis for Office

Symptom

How to use SAP Analytics Cloud as a repository in Analysis for Office?

Environment

SAP Analysis for Microsoft Office

Resolution

The feature is available from AO 2.8 SP18 and higher versions. Refer to this blog post for details and pre-requisites.

  • Please note that SAC will not generate a launcher file (.sapaox), as it is when saving workbooks to BW or to BI Platform.
  • When opening an Analysis Workbook in SAC, a file with extension .xlsx (or xlsm) will be downloaded.

Please note that the following features are not supported with the SAP Analytics Cloud repository:

  • You can't save workbook variants.
  • You can't schedule and precalculate Analysis workbooks.

See Also

Chapters "SAP Analytics Cloud" and "EnableSacAsRepository" in Administrator Guide

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

Keywords

sac, save, saving, stored, platform, opening, EnableSacAsRepository, workbooks, xlsx, sapaox , KBA , BI-RA-AO-XLA , Excel Addin , Product Enhancement

Product

SAP Analysis for Microsoft Office all versions