Working with Microsoft Add-ins

Rather than using SAP Analytics Cloud stories for data analysis and planning, you can use SAP add-ins to Microsoft Office, enabling 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

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.

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, 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)

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.

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