Presenting Analytics


After completing this lesson, you will be able to:

  • Describe how we present BW Query results using a report

Analysis for Microsoft Office Workbook

Scenario Overview

The final step is to present the results of the BW Query in a report that a business user would use.

BW Queries can be consumed by many different reporting tools, SAP and non-SAP. For our scenario we have chosen the on-premise tool SAP Analysis for Microsoft Office.

Another popular reporting tool is SAP Analytics Cloud

Analysis for Microsoft Office Workbook: terminology and use cases

Analysis for Microsoft Office is a front end reporting tool based on Microsoft Excel that includes a special SAP-provided add-in to provide extra tools for navigation of BW Query results.

An Analysis for Microsoft Office workbook is used to present the results from one or more BW Queries. It offers the possibility to analyze the data such as changing the layout (row, columns), adding filters, sorting data, and creating additional calculations.

Analysis for Microsoft Office Workbook: system settings

We will see how the report presents the sales transactions and also integrates the master data for products. In particular, look out for the following:

  • Products are displayed in a hierarchy
  • Description of each product is displayed
  • Product ABC Category and Gross Weight of products are displayed
  • Tax rate calculation is shown
  • Number of business partners that products are sold to is displayed

You can watch the following demo that explores the results of the BW Query:

Explore the BW Query results in SAP Analysis for Microsoft Office Workbook

Log in to track your progress & complete quizzes