Show TOC

Object documentationSAP NetWeaver BW Accelerator Index Locate this document in the navigation structure

 

A SAP NetWeaver BW accelerator index is a redundant data store of a BW object in the BW accelerator server.

 

BW Accelerator provides quick access to any data in the BW object with low administration effort, and is especially useful for sophisticated scenarios with unpredictable query types, high volumes of data and a high frequency of queries.

Structure

BW Accelerator index

A BW accelerator index contains all the data from a BW objects in a form which is compressed but not aggregated. The BW accelerator index stores the data at the same level of granularity as the BW object.

It consists of several (possibly distributed) indexes that correspond to the tables in the BW object, together with a “logical” index which, depending on the definition of the star schema, contains the metadata from the BW accelerator index.

BW Accelerator Server

The BW accelerator server is a TREX system as an installation of a BW Accelerator Engine. The data from the BW object is kept and processed entirely in the main memory of the BW accelerator server.

Note Note

BW Accelerator Engine is the part of the analytics engine that manages the BW accelerator index. This software allows the system to read data from, add data to or change data in the BW accelerator index. BW Accelerator Optimizer is the part of BW Accelerator Engine that ensures the best possible read access to a BW accelerator index. More information: Technical Information About SAP NetWeaver BW Accelerator Engine.

End of the note.

Integration

Maintenance Processes for BW Accelerator Indexes

The interface for BWA index maintenance allows you to create, activate, fill, edit and delete a BW accelerator index. More information: Indexing BW Data in the SAP NetWeaver BW Accelerator.

Like relational aggregates, a BW accelerator index is a redundant downstream data source that is used to improve query performance. Hierarchy and change run processes and processes for rolling up data are therefore derived from aggregate maintenance. For more information, see Rolling Up Data to SAP NW BW Accelerator Indexes and System Response Upon Changes to Data: SAP NetWeaver BW Accelerator Index.

BW Accelerator Index as InfoProvider for Reporting

At query runtime, analytical engine functions like aggregation, filtering, selection and some cell-based sorts are performed on the BW accelerator server.