Launching the SAP Analytics Cloud, Add-in for Microsoft Excel and Connecting it to an SAP Analytics Cloud Tenant

Objective

After completing this lesson, you will be able to launch the SAP Analytics Cloud, add in for Microsoft Excel and connect it to an SAP Analytics Cloud tenant.

Launch the SAP Analytics Cloud Add-In for Microsoft Excel

The SAP Analytics Cloud, add-In for Microsoft Excel is an add-in for Microsoft 365 that is launched from Microsoft Excel. Once installed, you launch it by simply creating a new workbook and navigating to the SAP Analytics Cloud ribbon.

See System Requirements and Technical Prerequisites for details on supported versions and configurations.

Microsoft Excel with the SAP Analytics Cloud, add-in for Microsoft Excel highlighted in the ribbon.

Connect to an SAP Analytics Cloud Tenant

To analyze SAP Analytics Cloud models, you must first connect to your SAP Analytics Cloud tenant.

You can connect by selecting the Sign In button on the left of the toolbar.

Microsoft Excel workbook with sign in options highlighted. 1. Sign in button on the ribbon. 2. Design panel on right side of the workbook.

If you have not connected to your SAP Analytics Cloud tenant before, you must first enter your tenant URL, then your SAP Analytics Cloud username and password in the Designer panel on the right side of the interface.

Note

A workbook can only be connected to one tenant at a time.

The Designer Panel

The Designer button in the ribbon opens the Designer panel, where you configure tables and data sources. The Designer button is context-aware: when you click it while an empty cell is selected, it shows the options Add Table and Add Data Source for Formulas directly, allowing you to start building your workbook immediately.

When a table is already present and selected, clicking Designer opens the panel showing the configuration for that table.

Summary

You should now be able to launch the SAP Analytics Cloud, add-in for Microsoft Excel and connect it to an SAP Analytics Cloud tenant.