Information

Please visit our international page to see all the numbers matching your region.

SAP Analysis Office - The Comprehensive Guide

SAP Analysis Office - The Comprehensive Guide

Part of:

Language

English

Pages

376

Edition

1

Level

Beginner

ISBN

9783960121695

Flat rate

$19 per month

  • Single license
  • 1000+ eBooks and video tutorials
  • Instant access
  • 12 months($228per year)
  • Automatic renewal

More Details

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.

  • Installation and settings including file system parameter
  • Basics like sorting and filtering data
  • Visualization and formatting of data
  • SAP Excel formulas and table design
  • VBA and how to use the API functionality
  • Detailed examples

Reading Example

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.

Frequentlyasked questions

General questions and answers about our learning content.

Who is the learning content suitable for?

The learning content is designed for anyone who wants to gain SAP knowledge in a simple, compact, and practical way. Our learning platform offers content for beginners, advanced learners, and experts. This enables you to expand your knowledge step by step and continuously develop your skills toward becoming an SAP expert.

What makes the learning content special?

Our products—whether books, videos, or online training—deliver SAP knowledge concisely and practically, so you can apply it directly in your daily work, even if you have limited time. You benefit from a broad coverage of relevant SAP topics, high-quality content in four languages, and learning formats designed to fit your individual needs. This ensures that you can stay up to date and continuously develop your expertise.

What distinguishes our books from those of other providers?

Our books are characterized by a clear practical focus and a compact, easy-to-understand presentation. We explain complex SAP topics concisely—without unnecessary marketing buzzwords—so readers can quickly grasp the essentials and apply the new knowledge directly.

Can the product be exchanged?

Our print books can be returned within 14 days, in original condition. Return shipping is at your own cost.

How can I order a book outside of Germany?

We currently only ship books directly within Germany. If you are ordering from outside Germany, we recommend purchasing via Amazon. You can find the link by selecting “Buy eBook” on any product in our webshop and Amazon will then show you both the eBook and print versions available for purchase.

Alternatively, you can access all our content with a digital subscription, starting at $19 per month.

Who can I contact if I have questions?

Our team is always happy to help and will respond to your questions as quickly as possible (usually within 1–2 days). You can also contact us if you have questions for one of the authors. Email: contact@espresso-tutorials.com

Support-Team

  • For more help, visit our documentation or click on Chat.