Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

BI Accelerator Index Design

Use

BI accelerator design provides information about the structure, properties and status of the 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

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


InfoCube


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.


Object Status


Status display:
BI accelerator index is filled.
BI accelerator index is not filled.


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 


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.


  • No labels