cancel
Showing results for 
Search instead for 
Did you mean: 

Statistics -Tables for BI Accelerator

Former Member
0 Kudos

Hi

What are the tables related to see Statistics for Maintenance Processes of a BI Accelerator Index .

thanks

Laurel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello

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

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

1)Initial indexing (see Using the BIA Index Maintenance Wizard)

2)Rollup (see Rolling Up Data in BI Accelerator Indexes)

3)Modifications after change runs (see System Response Upon Changes to Data: BI Accelerator Index)

<b>Prerequisites</b>

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

Hope it Helps

Chetan

@CP..

Answers (0)