Exploring Key Functionality and Data Sources

SAP Analytics Cloud can bring together a wide range of data from spreadsheets, on-premise databases, and the cloud.

Integrated with Microsoft 365, the SAP Analytics Cloud, add-in for Microsoft Excel lets you format, analyze, and enrich your data based on the latest content from the SAP Analytics Cloud platform.

You can access the add-in directly from the SAP Analytics Cloud ribbon in Microsoft Excel.

• You can add one or several tables to a workbook, each based on one SAP Analytics Cloud model.
• You can add or remove dimensions and measures to analyze your data.
• For all dimensions and measures, you can also create filters to narrow the scope of your analysis.
• If your analysis model includes dimensions with hierarchies applied, then you can expand and collapse the hierarchy nodes within the table.
• During your analysis and planning, you can update your table with the actual data from SAP Analytics Cloud at any time.
• For large datasets, you can switch a table to the high-volume mode, which allows the add-in to display significantly more data. Note that high-volume mode has limitations: planning, styling, conditional formatting, and adding new rows or columns are not available in this mode. You can switch to high-volume mode from the table's context menu.

The SAP Analytics Cloud, add-in for Microsoft Excel is available from Microsoft AppSource.

Information on deploying the SAP Analytics Cloud, add-in for Microsoft Excel can be found in the SAP Help Portal: Deploying the add-in.

Once the add-in is activated, you can analyze SAP Analytics Cloud analytic and planning models based on import data connections.

You can also work with the following data sources:

• SAP Datasphere datasets and analytics models,
• SAP S/4HANA Cloud queries, and
• SAP Business Warehouse queries.

You should now be able to describe the key functionality and list the data sources used in the SAP Analytics Cloud, add-in for Microsoft Excel.