SAP Business Warehouse uses OLAP technology to analyze data stored in the Data Warehouse.
Online Analytical Processing (OLAP) uses SAP Business Warehouse as a Decision Support System allowing decision makers to analyze multidimensionally modeled data quickly and interactively in line with business management needs.
InfoProviders provide the view of the data. Since the data in InfoCubes is stored in a read-optimized form, InfoCubes and MultiProviders based on InfoCubes are the preferred InfoProviders.
Analytic Manager, a component of the BW server, lies between the user and the database. It makes the multidimensionally formatted data available to the front end and, using special interfaces (Open Analysis Interfaces), to third-party administrator front ends. Analytic Manager is therefore optimized for analyzing and reporting large datasets. Users can request special individual views of business-relevant data using Business Explorer (see SAP Business Explorer).
Queries are the basis of every analysis in SAP Business Warehouse. To formally define a multidimensional request, a query defines the following:
The BW system has a number of analysis and navigation functions for formatting and evaluating a company's data. These allow the user to formulate individual requests on the basis of multidimensionally modeled datasets (InfoProviders). Users can then view and evaluate this data from various perspectives at runtime.
The overall functionality for retrieving, processing, and formatting this data is provided by Analytic Manager.
In the context of BW Integrated Planning, you can use input-ready queries for manual planning. More information: Planning Business Data with BW-Integrated Planning and Input-Ready Query.
The table below provides an overview of the OLAP functions and services implemented in Analytic Manager in SAP Business Warehouse.
OLAP Function | Operations in Detail |
---|---|
Navigation |
Drilldown to characteristic / structure element. Remove element drilldown from the view (dice) Expand (drilldown) and hide (drill up) hierarchy nodes Swap drilldown elements |
Filter |
Restrict (slice) characteristics to selections (single value, value range, hierarchy element, exclusion) |
Aggregation |
Standard aggregation: Default, key-figure-dependent calculation formula for the aggregation of single result values Exception aggregation: Special aggregation setting in relation to a particular characteristic. Aggregation average of account balance with reference to the time characteristic for example Local aggregation or local calculations (calculation of individual values displayed for normalization to the overall result for example) |
Display |
Characteristics displayed as key/description Display/suppress results rows Change position of hierarchy nodes (up/down) |
Result-dependent selection and display |
Threshold values (exceptions): Colored highlighting of uncommon variances in key figure values Conditions: Key-figure-dependent restriction of characteristics according to defined conditions |
Structuring |
Hierarchical assignment of characteristic values with drill down for more than one element ('Universal Display Hierarchy') |
Generic and business analysis functions |
Sorting with reference to characteristics and key figures Calculated key figures and formulas (enables statistical and mathematical calculation on the basis of key figure values) Currency translation Elimination of internal business volume (business elimination of internal transactions) |
Concepts for runtime optimization |
OLAP Cache (can be implemented in cache mode, depending on the query) Non-Cumulatives Aggregates Note
Note that you can optimize performance by storing data from BW objects in the SAP HANA database as an index on the SAP Business Warehouse Accelerator server. You manage these BWA indexes in the BW system. |
Integrated additional functions |
Variables for parameterization and greater reusability of queries Report-report interfaces for navigation in different reports Authorization concept for setting user authorizations for accessing data |