Show TOC

Displaying a SAP BW Accelerator IndexLocate this document in the navigation structure

A SAP BW Accelerator index provides information about the structure, properties and status of the SAP BW Accelerator index and its tables/indexes.

Tables that are part of the enhanced star schema of the selected InfoCube and are required in the corresponding BW accelerator index form part of the description of the BW accelerator index.


All the dimension tables of the InfoCube are required for the star schema of the BW accelerator index. The E and F fact tables of the InfoCube form one fact index. Of the master data tables, only the X and Y tables (which contain the SIDs) are required; the P and Q tables (which contain the key values) are not required. The SID tables (S tables) are required if the InfoObject has a non-numeric key.


In BW Accelerator Monitor, the system shows more information than in BWA index maintenance. The table below provides an overview of this information. * indicates that the column is displayed in BWA index maintenance as well as in BW Accelerator Monitor.



Objects in BWA Index

Technical names of the BW objects that BW Accelerator indexes were created for

BWA Index Type

Type of BWA index. See Indexing BW Data in SAP BW Accelerator.

Object version

Status display:

BW Accelerator index is active.

BW Accelerator index is inactive.

See Activating and Filling SAP BW Accelerator Indexes.

Object status

Status display:

BW Accelerator index is filled.

BW Accelerator index is not filled.

See Activating and Filling SAP BW Accelerator Indexes.

Table Name *

Technical name of the relevant index on the BW accelerator server.

Table Size *

Specifies the approximate current size of the individual tables (number of data records), as calculated from the database statistics.

Index Status *

Status of index

with Delta Index *

Selection - if a delta index is used for the BW Accelerator index (see Improving Efficiency Using BWA Delta Indexes).

Last Changed By *

Name of user who made the last change.

Last Changed/Time Stamp *

Date and time of last change.


BWA index-specific information can be displayed in BWA index maintenance and in BWA Accelerator Monitor.

BWA Index Maintenance

As soon as a BW Accelerator index has been created, the system displays information about its tables and indexes on the Index Info tab page (see Indexing BW Data in SAP BW Accelerator).

BW Accelerator Monitor

If you choose Start of the navigation path BW Accelerator Next navigation step Index Information Next navigation step Display All BWA Indexes End of the navigation path, the Information about BWA Indexes dialog box appears. The system displays all existing BW Accelerator indexes in the system.