About SteffenHeine

SteffenHeine

This blog guides users on creating asymmetric table structures with the help of the newly introduced SAP.BLOCK and SAP.ASYMMETRICFILTER formulas. These formulas significantly improve table filtering, allowing users to apply asymmetric filters, e.g. t...

SteffenHeine

The SAP Analytics Cloud license includes two Microsoft Excel add-ins: the strategic SAP Analytics Cloud add-in for Microsoft Excel and SAP Analysis for Microsoft Office (SAC edition). The SAP Analytics Cloud add-in for Microsoft Excel is automaticall...

SteffenHeine

Since QRC3 2023, SAP Analysis for Microsoft Office 2.8 (AO) has made it possible to store workbooks on SAP Analytics Cloud (SAC). Three blogs have provided an overview about the two SAP Analysis for Microsoft Office editions, the replace system featu...

SteffenHeine

Until now, the SAP Analytics Cloud, add-in for Microsoft Office could be connected to native SAP Analytics Cloud models, SAP Datasphere and SAP S/4HANA Public Cloud (for more information, see SAP Help). With the QRC4 release on November 20, 2023, use...

SteffenHeine

SAP Analysis for Microsoft Office workbooks can be saved locally, on SAP Business Warehouse or on the SAP Business Intelligence Platform. With 2.8 SP18 or higher workbooks can be also saved on the SAP Analytics Cloud repository. SAP Analytics Cloud a...

SteffenHeine

Hi Christian, I am calling the keyboard shortcut for Refresh All: Call SendKeys("+^%{F5}", True)https://help.sap.com/docs/SAP_ANALYTICS_CLOUD_OFFICE/c637c9ff5d61457eb415ce161e38e57b/559e9547681e479a992c7bed9696058a.htmlRegards, Steffen

SteffenHeine

Hi jmoon, yes this will work. In the example above you would use in the first SAP.BLOCK formula for the time dimension the quarter values e.g. 20241 (for Q1 2024) as filter.

SteffenHeine

Hi Nikhil,SAC Excel add-in stores the URL within the workbook. So when you open it it connects to this URL automatically. Lifecycle is currently not straight forward. You need to use Replace Tenant to switch to the QA/Prod tenant: https://help.sap.co...

SteffenHeine

@wolfgang_ziegler01 Thanks for the feedback. Available dimensions and text selection are on the roadmap for 2025. For right-click we are waiting for an API from Microsoft. Feel free to also add your requirements into SAP Influence: https://influence....

SteffenHeine

Here you find the official help page: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_ANALYSIS_OFFICEYou need to download Analysis Office from the SAP Software Download Center: https://me.sap.com/softwarecenter

User Statistics

User Activity

Build a dynamic rolling forecast with SAP Analytics Cloud, add-in for Microsoft Excel

Comparison of SAP Analysis for Microsoft Office (SAC edition) vs. SAC add-in for Microsoft Excel

SAP Analysis for Microsoft Office - Move workbooks from BI Platform to SAP Analytics Cloud

Live access to SAP S/4HANA Private Cloud and SAP BW in SAP Analytics Cloud, add-in for Microsoft Office

SAP Analysis for Microsoft Office – Storage of workbooks

Re: Build a dynamic rolling forecast with SAP Analytics Cloud, add-in for Microsoft Excel

Re: Build a dynamic rolling forecast with SAP Analytics Cloud, add-in for Microsoft Excel

Re: Comparison of SAP Analysis for Microsoft Office (SAC edition) vs. SAC add-in for Microsoft Excel

Re: Comparison of SAP Analysis for Microsoft Office (SAC edition) vs. SAC add-in for Microsoft Excel

Re: SAP S/4HANA Public Cloud for group reporting with SAP Analysis for Microsoft Office