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:
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.
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:
- 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
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?
Hi Kenneth, SP14 will be released this week! Latest Friday morning you find it in the download portal.
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?
Please forget this. I did rigth click and the option was there.
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
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,
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?
no SAC nor DWC connection nodes
in your blog post, you gave the following hint:
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)
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 2.8 SP14
Do I need to install any other software's? Or Excel version is causing this?
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.
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.
Great to hear that Analysis for Office now supports direct consumption of DWC data!
Are there any limits regaring maximal amout of cells? Or are the limits the same like using BW live? (I'm asking because "SAP Analytics Cloud, add-in for Microsoft Office" has limits consuming DWC data.)
Many thanks in advance!
same limitations as for SAP Analytics Cloud, add-in for Microsoft Office which relate to the backend.
2770570 - Error message "The select returned more records than the limit in MaxResultRecords" / MDS Cube resultset & cell size limit
I can't find how to share file? It can save platform in DWC?