SAP Career Guide - A beginner’s manual on SAP careers for students and professionals

“I wish I had been able to read this tutorial earlier.”

O. Lázaro Arriola

SAP Analysis Office - The Comprehensive Guide

This book explains how you use SAP BusinessObjects Analysis Office to support your reporting needs. BusinessObjects Analysis Office combines the existing experience with BEx reporting, with the additional pivoting functionality offered by Microsoft.Instal...

Reading sample
Learn for free for 7 days now

Table of content

  • Foreword
  • Introduction
  • 1 Analysis Office versus BEx Analyzer
  • 2 Installation and configuration
  • 3 Customizing Analysis Office
  • 4 Basics
  • 5 Advanced functions
  • 6 Company Functions
  • 7 Reporting with API and VBA
  • 8 Examples of Excel dashboards
  • 9 Troubleshooting
  • 10 SAP Analytics Cloud
  • A Appendix
  • B The Author
  • C Disclaimer

More Information

Author:

Tobias Meyer

Category:

Analytics

Language:

Englisch

Reading sample

2.1   System requirements

Before you install Analysis Office, check if the following components are installed on your local machine:

  • Microsoft Office 2010, Microsoft Office 2013, Microsoft Office 2016, Microsoft Office 2019 or Office 365
  • Microsoft .Net Framework 4.5 Redistributable Package

Microsoft .Net Framework

During installation, the setup checks whether Microsoft .Net Framework 4.5 is installed. If not, a link is provided to download the .Net Framework. The setup also checks whether Primary Interop Assemblies are installed. If not, the setup installs the components automatically.

I recommend taking a look at SAP Note 1466118—”Hardware & Software requirements for Advanced Analysis”—which explains the hardware and software requirements for SAP Analysis, the edition for Microsoft Office.

The SAP GUI installation is not mandatory on your client. If you use Analysis Office only as a reporting application, you can skip the installation as well as the BW add-on installation for the BEx tools. Nevertheless, I suggest installing the SAP GUI and the BEx tools because when you want to change or create a new query, you need the BEx Query Designer. Otherwise, you need to use the Eclipse-based Query Designer, in which case you do not need the SAP GUI. You also need the SAP GUI if you want to use the Report-Report-Interface (for more information see Section 5.8).

A local copy of SAPLOGON.INI is required if you want to connect to an SAP NetWeaver BW. If you want to switch directly from Analysis Office to BEx Query Designer (see Section 5.15.3), you need to install the SAP GUI and the BEx tools. As data sources, you can use SAP NetWeaver 7.0 or a higher release, BW/4HANA, SAP HANA or SAP Analytics Cloud models.

Report-Report-Interface (RRI)

If you want to use the Report-Report-Interface (RRI) to jump directly to an SAP transaction, you need to install the SAP GUI on your client. However, be aware that only the web interface is available.

All content - Learn for 7 days now, free of charge and with no obligation.

7 days of free and unlimited access to all learning content1 und den Espresso Tutorials SAP-Copiloten Espressi.

1
Enter mail
2
Confirm mail
3
Learn 7 days

1. You can unsubscribe from the Espresso Tutorials newsletter at any time by clicking on Unsubscribe in an email from the newsletter.

Already have an account? Log in now.

1 You will have access to all learning content included in the Silver subscription. Certificates are part of the Gold subscription. Online training courses are NOT part of the Digital subscription.