SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud

SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud, is a pure Microsoft Excel add-in designed for SAP Analytics Cloud users.

Analysis is a Microsoft Office add-in that allows multidimensional analysis of data sources in Microsoft Excel and MS Excel workbook application design.

It allows you to analyze and plan with data sources from SAP Analytics Cloud, SAP BW, SAP BW/4HANA, and SAP HANA.

It is available for the following Microsoft Office versions:
  • Office 365 (Excel)
  • Microsoft Office 2019 (Excel)
  • Microsoft Office 2016 (Excel)

In Microsoft Excel, Analysis is available in two separate tabs in the ribbon: Analysis and Analysis Design.

With Analysis, you can use SAP Analytics Cloud models, SAP BW data sources from the BI platform or from a BW system, and SAP HANA data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems. If the workbook will be used by different users, you can also add info fields with information on the data source and filter status.

Using the design panel, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step, you can pause the refresh to build a crosstab. After ending the pause, all changes are applied at once.

You can refine your analysis using conditional formatting, filter, prompting, calculations and display hierarchies. You can also add charts to your analysis. If you want to keep a status of your navigation, you can save it as an analysis view. Other users can then reuse your analysis.

For more sophisticated workbook design, Analysis contains a dedicated set of functions in Microsoft Excel to access data and meta data of connected systems. There are also a number of API functions available that you can use with the Visual Basic Editor, to filter data and set values for variables.

You can also plan business data based on the current data in your data source. You can enter the planning data manually and you can enter planning data automatically using planning functions and planning sequences of SAP BW Integrated Planning.

Analysis must be installed on your local machine. You can connect directly to a system or you can connect via a platform to include data sources. You can use the following platforms to store and share workbooks: SAP BusinessObjects business intelligence platform and SAP BW / SAP BW/4HANA.

You can find more information about Analysis on the SAP Help Portal at SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud.