Introducing the SAP Analytics Cloud Add-In for Microsoft Office

SAP Analytics Cloud, add-in for Microsoft Office enables you to use Microsoft Excel’s strengths to get deeper insights into your SAP Analytics Cloud data.

SAP Analytics Cloud can bring together a wide range of data from spreadsheets, on-premise databases, and the cloud. With SAP Analytics Cloud, add-in for Microsoft Office, you can bring this data into Microsoft Excel and take your analysis a step further.

Integrated with Microsoft Office 365, the add-in lets you format, analyze, and enrich your data based on the latest content from the SAP Analytics Cloud platform. You can also analyze SAP Analytics Cloud analytic models based on import data connections.

You can insert one or several models in a workbook. Then you can add or remove dimensions and measures to analyze your data. You can also add totals in rows and columns to your table.

In your analysis, you can use dimensions with hierarchies applied. You can expand and collapse the hierarchy nodes within the table.

Let's take a look at how SAP Analytics Cloud, add-in for Microsoft Office enriches SAP Analytics Cloud.

Note

Data locking, cell locking, comments, and data actions are not supported in Analysis for Microsoft Office or the SAP Analytics Cloud Add-in.

The figure below shows the planning features available in SAP Analytics Cloud, add-in for Microsoft Office.

To use the online version, there are four trusted origins:

1. https://sapanalytics.cloud

2. https://*.live.com

3. https://*.sharepoint.com

4. https://*.online.office.de

To view the trusted origins, see: System → Administration → App Integration → Trusted Origins.

The Desktop version of the Add-In is supported and can provide more flexibility than the on-line version. In fact, it is the primary option for Excel integration.

Note

For Excel desktop, the add-in requires one of the following versions connected to a valid Microsoft 365 subscription:

• version 16.30 or higher on Excel for Mac

• version 2005 or higher on Excel Current Channel for Windows

• version 2004 or higher on Excel Monthly Enterprise Channel for Windows

• version 2002 or higher on Excel Semi-Annual Enterprise Channel for Windows

• https://appsource.microsoft.com/en-us/product/office/WA200000169

Watch this video to learn how to plan with SAP Analytics Cloud Add-in for Microsoft Office.