Access SAP Data Warehouse Cloud with SAP's Microsoft Excel add-ins

[steffen_heine]

With SAP Analysis for Microsoft Office and SAP Analytics Cloud, add-in for Microsoft Office, SAP is providing two solutions to plan and analyze data in a familiar Excel interface.

SAP Analytics Cloud, add-in for Microsoft Office with its smooth deployment and cross-platform support has already access to SAP Data Warehouse Cloud datasets since Q4 2021. This helps to combine planning models in SAP Analytics Cloud with any actuals from SAP Data Warehouse Cloud. With the latest release this April there is also prompt support.

To support customers with their transition to the cloud, SAP Analysis for Microsoft Excel workbooks can be enriched with SAP Data Warehouse Cloud data from version 2.8 SP14.

Access SAP Data Warehouse Cloud with SAP Analytics Cloud, add-in for Microsoft Office:

Just connect to your SAP Analytics Cloud tenant and choose the SAP Data Warehouse Cloud Live connection as described here. With the April 2022 release you will get the new prompt dialog automatically:

Prompt support

Access SAP Data Warehouse Cloud with SAP Analysis for Microsoft Office 2.8 SP14:

Both editions (see differences for each license on PAM page 6) of SAP Analysis for Microsoft Office support direct access to SAP Data Warehouse Cloud.

Insert a new data source for analysis. In the connection dialog tree view, there is a new connection type SAP Data Warehouse Cloud. Via right-click create a new connection and maintain description and URL of the tenant.

Create connection

After the successful logon with the SAP Data Warehouse Cloud user, the search for analytical datasets opens:

• The user is able to search for description or technical name of the dataset. Also, the direct search can be used to search for all datasets in a certain space


• The area tab lists all assigned spaces with its analytical datasets

Select the dataset, maintain possible prompts, and start analyzing as usual:

Crosstab

Hints:

• The preferred platform must be selectable to see the new SAP Data Warehouse Cloud connection type


• Going forward we are switching the embedded Internet Explorer based logon to the default browser of the machine. This setting UseExternalBrowserForDwcLogon is already available, but by default deactivated until the changes are released on all SAP BTP landscapes. With SP17 this setting will become default (added on Feb 3, 2023)


• Analysis for Office only supports Analytical Datasets. Analytic Models are not supported. See Note 3297935 (added on Feb 3, 2023)


• Further info and limitations are listed on the SAP Help page