SAP BusinessObjects Analysis (Office)

SAP BusinessObjects (BO) Analysis (Microsoft Office edition) is an analysis tool for multidimensional data (OLAP analysis). As of version 2.5, it consists of three plug-ins: Analysis Plug-in, EPM Plug-in and BPC Plug-in. These plug-ins have been merged into one Microsoft Office add-in. They support cross-table analysis in Excel along with the creation of Excel-based reports with alerting and highlighting features as well as flexible report layouts.

SAP was founded in 1972 by five former IBM employees but really came into prominence in the 1990s with the ERP boom. The vendor employs over 87,000 people worldwide and has a turnover of over €22bn. It is one of the largest business software vendors in the world.

Today, SAP follows a dual analytics strategy aimed at delivering continued innovations for on-premises solutions while building new cloud solutions. This product review will focus on SAP BusinessObjects Analysis for Microsoft Office (Analysis Plug-in).

SAP BO Analysis for Office (Analysis Plug-in) typically supports NetWeaver (SAP BW), SAP BO BI platform or SAP Analytics Cloud using the respective repository with its structure and authorizations.

Analysis for Office is an Excel-add-in for ad hoc and multidimensional analysis aimed at business users. The Analysis Plug-in can be seen as a replacement for BEx Web Analyzer and BEx Analyzer (BW front ends in maintenance mode) due to its native connectivity to BW. Data is displayed in crosstabs.

Typical multidimensional operations are used to query data, including slice and dice, drill-down and drill-up and so on.

User & Use Cases

SAP BusinessObjects Analysis is an Excel add-in that focuses on multidimensional (OLAP) analysis. Customers report using the product mostly to query various data sources ad hoc.

SAP originally developed it as the successor product to BEx Analyzer, which is also an Excel add-in for querying and analyzing BW data and creating standard reports. When BEx Analyzer was put into maintenance mode, customers struggled to find an appropriate replacement. Indeed, they still seem to be comparing the products. However we are seeing more and more BEx customers adopting and using SAP BO Analysis in very similar scenarios to BEx Analyzer.

Due to the fact that the Analysis Plug-in supports data sources such as BW and HANA, it is mostly used in large scenarios. The low percentage of employees using the product shows that it is often used by power users, who are mostly in financial departments, for analysis and creating standardized financial reports.

Current vs. planned use

N = 34

Business Intelligence Use Cases of SAP BO Analysis

5 products most often evaluated in competition with SAP BO Analysis

N = 33

5 products most often evaluated in competition with SAP BO Analysis

Percentage of employees using SAP BO Analysis

N = 31

Percentage of employees using SAP BO Analysis

Number of users using SAP BO Analysis

N = 33

Number of users using SAP BO Analysis

Tasks carried out with SAP BO Analysis by business users

N = 33

Tasks carried out with SAP BO Analysis by business users

Company size of SAP BO Analysis users

N = 33

Company size of SAP BO Analysis users

Want to see the whole picture?

Purchase the Vendor Performance Summary

Contains a product review by BARC's analyst team plus user ratings from The BI Survey 17

SAP BusinessObjects Analysis (Office)

Peer Groups OLAP analysis-focused products
VendorSAP SE
Number of responses34
OfficesWorldwide
Employees87,100+
Customers355,000+ (not only BI)
Revenues (2016)€22.06 Billion (FY 2016)
Web sitewww.sap.com