Show TOC

Online Analytic ProcessorLocate this document in the navigation structure

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.

Table 1: Overview of OLAP Functions and Services
OLAP Function Operations in Detail


Drilldown to characteristic / structure element. Remove element drilldown from the view (dice)

Expand (drilldown) and hide (drill up) hierarchy nodes

Swap drilldown elements


Restrict (slice) characteristics to selections (single value, value range, hierarchy element, exclusion)


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)


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


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)




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