Skip to Content
Product Information
Author's profile photo Steffen Heine

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

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%20support

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%20connection

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

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
  • Further info and limitations are listed on the SAP Help page

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kenneth Dalvik
      Kenneth Dalvik

      Hi, This great news. However I could not find AOFFICESACSP14 file on the download portal. Any tips on how to get my hands on it?

      Author's profile photo Steffen Heine
      Steffen Heine
      Blog Post Author

      Hi Kenneth, SP14 will be released this week! Latest Friday morning you find it in the download portal.

      Author's profile photo Liliana Gil
      Liliana Gil

      Hi Steffen Heine , I've just intalled SP14 Patch0 for ANALYSIS OFFICE CLIENT 2.8 but I cannot see the  new connection type SAP Data Warehouse Cloud. Any idea what is missed?

      Thanks,

      Liliana

      Author's profile photo Liliana Gil
      Liliana Gil

      Please forget this. I did rigth click and the option was there.

      Author's profile photo Martin Kreitlein
      Martin Kreitlein

      Hello Steffen,

      nice Blog!

      If you have a customer who migrated to S/4HANA recently, and now wants to setup his reporting via DWC & SAC, which of the 3 Add-ins would you recommend for consuming CDS Queries out of S4 (e.g. from the Business Analytics Apps) and data from DWC in Excel?

      Would you need the expenisve BPC license to use the AO Standard Edition - only for reporting - even if you don't want to plan with it?

      The license jungle is quite dense.

      Thanks and BR, Martin

      Author's profile photo Steffen Heine
      Steffen Heine
      Blog Post Author

      Hi Martin,

      the strategic direction goes towards SAP Analytics Cloud Excel add-in. Nevertheless it does not have the S/4 CDS connectivity yet and you would need to access them via DWC.

      Therefore, as of today I would recommend Analysis for Office, SAC edition. It comes with the cheaper SAC license and has access to SAC, DWC and S/4 CDS queries for reporting. Even it is not needed you could do also BPC planning with it. The SAC edition does not include scheduling support, the EPM add-in and the BPC activity pane integration. But if that is needed I would recommend this.

      Hope this helps,

      Steffen

      Author's profile photo Rinyapat Leerasuntornrangsri
      Rinyapat Leerasuntornrangsri

      Hi Steffen,

      I just installed the AOFFICE28SP14_0-70004974 and using Excel with 365 subscription.

      However, I could not see SAP Analytics Cloud nor SAP Data Warehouse Cloud nodes in the connection list.

      Could you suggest? or I should install the ANALYSISOFFICE_FOR_SAC 2.8 instead.

      If not, is there any missing configuration to enable live connections?

      Thanks,

      Rinyapat.

      no%20SAC%20nor%20DWC%20connection%20nodes

      no SAC nor DWC connection nodes

      Author's profile photo Patrick Vogt
      Patrick Vogt

      Hi there,

      in your blog post, you gave the following hint:

      • 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

      My question would be: Where can I see if our SAP BTP landscape (eu10) has the mentioned change? I just ask because our company has blocked IE11 now on all machines (due to the end of the maintenance) and the External Browser option is not working for us at the moment, even when activated via the config file (the opened (oauth-)URL in the external browser is rejected with an HTTP 400 - bad request by the corresponding tenant)

      Best Regards
      Patrick

      Author's profile photo Prasanna Korada
      Prasanna Korada

      Hi Steffen,

      Thanks for this document. I have installed AOFFICE28SP14P_1-70004973.EXE (SP14 Patch1 for ANALYSIS OFFICE CLIENT 2.8) successfully (Excel version - Office 365(version 2016)) but I am not seeing "SAP DWC connection" but I do see "Create New SAP HANA Connection".

      OA%202.8%20SP14

      OA 2.8 SP14

      Do I need to install any other software's? Or Excel version is causing this?

      Thanks

      Prasanna Korada

       

      Author's profile photo Prasanna Korada
      Prasanna Korada

      Nevermind, I am able to add SAP DWC connection now, we had selected SAP BW as a “Preferred Platform”  which was blocking to show SAP DWC connection.

       

      Author's profile photo Prasanna Korada
      Prasanna Korada

      Nevermind, I am able to add SAP DWC connection now, we had “Preferred Platform” as a SAP BW, which was blocking to show SAP DWC connection.