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.
Note
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: