A SAP NetWeaver BW Accelerator index provides information about the structure, properties and status of the SAP NetWeaver 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.
Column |
Description |
---|---|
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 NetWeaver BW Accelerator. |
Object version |
Status display: BW Accelerator index is active. BW Accelerator index is inactive. See Activating and Filling SAP NetWeaver BW Accelerator Indexes. |
Object status |
Status display: BW Accelerator index is filled. BW Accelerator index is not filled. See Activating and Filling SAP NetWeaver 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 NetWeaver BW Accelerator).
BW Accelerator Monitor
If you choose BWA Indexes dialog box appears. The system displays all existing BW Accelerator indexes in the system.
, the Information about