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

Statistics for Maintenance Processes of a BI Accelerator Index

Use

To get an overview of the runtimes of specific subprocesses in BI accelerator index maintenance, you can display the RSDDSTATTREX table.

For the following processes, the system writes the runtimes of specific subprocesses to this statistics table:

  • Initial indexing
  • Rollup
  • Modifications after change runs

Integration

Some BI accelerator tests in the analysis and repair environment work with statistics data.

Prerequisites

The statistics have to be switched on for the relevant InfoProviders. You make this setting in statistics properties maintenance (on the Data Warehousing Workbench screen, choose Tools -> Settings for BI Statistics).

Features

The statistics table contains the following information for each table that is indexed:

RSDDSTATTREX 


Column


Description


STATUID 


Unique identification key


TABLNM 


Table name


CHANGEMODE 


Specifies whether the process is part of a BI accelerator rebuild ("N"), the rollup ("R") or a modification after a change run ("C").


FILLMODE 


Fill Mode: Full ("F"), delta ("D") or change run ("C") 


TIMEACTIVATE


Time of activation


TIMEREAD


Time required to read data from the database


TIMEFILL


Time required for packing and indexing


TIMEOPTIMIZE


Time for Prepare Optimize


TIMECOMMIT


Time for Commit Optimize


REC_INSERTED


Number of indexed records


TSTPNM


User


TIMESTMP


Start time stamp

  • No labels