SAP NetWeaver BI Accelerator Index Design

Use

The design of a SAP NetWeaver BI accelerator index provides information about the structure, properties and status of the SAP NetWeaver BI 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 BI accelerator index form part of the description of the BI accelerator index.

All the dimension tables of the InfoCube are required for the star schema of the BI 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.

Integration

BIA index-specific information can be displayed in BIA index maintenance and in the BI accelerator monitor.

BIA Index Maintenance

As soon as a BI accelerator index has been created, the system displays information about its tables and indexes on the  Index Info tab page (see Using the BIA Index Maintenance Wizard).

BI Accelerator Monitor

If you choose BI Accelerator ® Index Information ® Display All BIA Indexes, the Information about BIA Indexes dialog box appears. The system displays all the BI accelerator indexes that exist in the system.

Features

In the BI accelerator monitor, the system shows more information than in BIA index maintenance. The following table provides an overview of this information. * indicates that the column is displayed in BIA index maintenance as well as in the BI accelerator monitor.

Description of a BI accelerator index

Column	Description
InfoCubes	Technical name of the InfoCubes for which BI accelerator indexes have been created
Object Version	Status display:  BI accelerator index is active.  BI accelerator index is not active. See Activating and Filling SAP NetWeaver BI Accelerator Indexes
Object Status	Status display:  BI accelerator index is filled.  BI accelerator index is not filled. See Activating and Filling SAP NetWeaver BI Accelerator Indexes
Table Name *	Technical name of the relevant index on the BI 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 *	Indicates that a delta index is being used for the BI accelerator index (see Improving Efficiency Using SAP NetWeaver BI Accelerator Delta Indexes).
Multiple Usage *	With S, X and Y tables, this indicates that one of the tables is already being used by another BI accelerator index and therefore already exists as an index.
Last Changed By *	Name of user who made the last change.
Last Changed/Time Stamp *	Date and time of last change.