Working with Microsoft Add-ins

Objective

After completing this lesson, you will be able to describe the Microsoft Office integration options to SAP Analytics Cloud stories.

Microsoft Office Integration with SAP Analytics Cloud

SAP Add-Ins to Microsoft Office

Rather than using SAP Analytics Cloud stories for data analysis, planning, and presentation, you can use SAP add-ins to Microsoft Office.

The SAP Analytics Cloud, add-in for Microsoft PowerPoint allows you to you to embed SAP Analytics Cloud widgets in your PowerPoint presentation.

The SAP Analytics Cloud, add-In for Microsoft Excel and SAP Analysis for Microsoft Office enable you to use Excel to format, analyze, and enrich your SAP Analytics Cloud data.

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.

There are also several formula functions provided that can be used for filtering, reading meta data, and creating cell-based reports. For example, SAP.GETDATA returns the data value for a specified set of dimension and member combinations.

Finally, both add-ins accommodate planning capabilities, such as:

  • Write-back
  • Revert
  • Publish
  • View changed cells with automatic highlighting
  • Add filters, subtotals, navigation attributes, properties

You can download all of the add-ins from the Microsoft Office store.

SAP Analytics Cloud, Add-In for Microsoft Excel

Watch this video to learn more about SAP Analytics Cloud, add-in for Microsoft Excel.

With SAP Analytics Cloud, add-in for Microsoft Excel, you can bring your SAP Analytics Cloud data into Microsoft Excel and continue your analysis there. In this example, you can see the additional SAP Analytics Cloud tab displayed in the Microsoft Excel ribbon as well as sample formula functions available.

Sample table in the SAP Analytics Cloud, add-in for Microsoft Excel

Additional Information

SAP Analytics Cloud, add-In for Microsoft Excel is covered in more detail in the Creating and Working with Microsoft Excel Workbooks Using the SAP Analytics Cloud, Add-in for Microsoft Excel learning journey.

SAP Analysis for Microsoft Office

SAP Analysis for Microsoft Office, commonly referred to as Analysis for Office, is a Microsoft Office add-in that allows multidimensional analysis of SAP data sources, including SAP Analytics Cloud. It consists of the following plug-ins:

  • Analysis
  • Enterprise Performance Management (EPM)
The SAP Analytics Cloud live connection and data sources with the resulting crosstable in the Excel worksheet for SAP Analysis for Microsoft Office.

Watch this video to learn more about the SAP Analysis for Microsoft Office.

Note

While SAP Analysis for Microsoft Office can also be used to plan on SAP Analytics Cloud data, all future development regarding SAP Analytics Cloud will be on the SAP Analytics Cloud, add-in for Microsoft Excel.

Additional Information

The SAP Analysis for Microsoft Office add-in is covered in more detail in the Discovering SAP Analysis for Microsoft Office learning journey.

SAP Analytics Cloud, Add-in for Microsoft PowerPoint

SAP Analytics Cloud, add-in for Microsoft PowerPoint is web-based and available with both PowerPoint for Web on Windows and Mac.

Once you connect to your SAP Analytics Cloud tenant and have added a widget to your PowerPoint slide, you can refresh the widget's data at any time. There is no need to go back to SAP Analytics Cloud to copy the information and paste it into your slide each time there is an update to the data.

Using the add-in, you can easily find SAP Analytics Cloud stories and associated widgets, filter widget data as required, and add widgets to your PowerPoint slide.

SAP Analytics Cloud, add-in for Microsoft PowerPoint with the add-in tab in the ribbon highlighted at the top of the screen and the SAP Analytics Cloud panel open on the right (also highlighted).

Note

An SAP Analytics Cloud license is required to access data with the SAP Analytics Cloud, add-in for Microsoft PowerPoint

Log in to track your progress & complete quizzes