SAP Analysis for Microsoft Office

SAP Analysis for Microsoft Office (aka AO or AFO) is designed for financial analysts who require analytical capabilities in Microsoft Excel on SAP data sources like SAP BW, SAP S/4HANA and SAP Business Planning & Consolidation. It can also be... Read More »

Microsoft Office is a commonly-used word processing suite among many companies today. if you’ve got SAP installed, you have much flexibility in combining both of these software suites into something seamless and integrated. However,... Read More »

What is System Replacement? Any Excel workbook with SAP Analysis for Microsoft Office content such as a crosstab from a Data Source has information about the particular backend system that Data Source belongs to. There are scenarios that the... Read More »

Summary Active/Active (Read Enabled) enables SAP HANA system replication to support read access on the secondary system. It reduces the load on the primary and has been available with SAP HANA 2 SPS00 to route SQL requests to the secondary... Read More »

Introduction It is now possible to connect to SAP Analysis for Microsoft Office with your SAP S/4HANA Cloud system. These are the pre-requisites: SAP Analysis for Microsoft Office is installed (2.8.15 and Higher) and you can download it from:... Read More »

During the last quarter we have delivered lots of great features to SAP Data Warehouse Cloud. Join our product update sessions and get to know the major features delivered in Q2 2022. The session on July 27th, 2022 will run one hour and covers the... Read More »

The SAP Analytics Business Intelligence Statement of Direction (SoD) provides guidance to our SAP BusinessObjects customers on the product directions of SAP Analytics Cloud and SAP BusinessObjects solutions. The SoD got some important updates this... Read More »

SAP’s Jeanne Bigonnet joined us recently to discuss the latest updates for SAP Analysis for Office (AO), including both the Standard Edition for SAP BusinessObjects and the Edition for SAP Analytics Cloud. Jeanne began by outlining the history of... Read More »

Here is the summary of what is covered in this article: Introduction and Inserting formula data source. How to define SAPGetData formulas in Analysis for office. Usage of SAPSelectMember formula in SAPGetData. Introduction and Inserting formula... Read More »

Introduction: This blog post is on usage of two powerful Nodes namely Hierarchy function and Minus Node in HANA Calculation view. Both Nodes are available in SAP HANA 2.0 XSA and HANA cloud. Minus and Hierarchy function Node are available starting... Read More »