To get an overview of the runtimes of specific subprocesses when processing analytic indexes, view the RSL_STAT table.
The statistics have to be switched on for the relevant analytic indexes. You can configure this in the statistics properties maintenance screen. In the Data Warehousing Workbench, choose
.The statistics table RSL_STAT contains the following information:
Column |
Description |
STATUID |
Unique identification key of process (for example, load) |
OBJNM |
Name of analytic index |
COMP_TYPE |
Type of component (FACTS = facts, DIM = dimension, AUTH = authorizations). When facts are loaded, any available dimension data is also written because the dimension indexes and fact index are always linked by an inner join (otherwise the result is empty for queries). |
COMP_ID |
Unique identification key of component (= name of dimension if the type is DIM) |
PART_ID |
Part of process: Only needed for asynchronous processing with Batch Manager (only APD, not BW Workspace). It is temporary, as subprocesses are aggregated in the end result. |
CHANGEMODE |
Type of change: A = Add data, F = Reload data, T = Delete data, C = Create BWA storage, D = Delete BWA storage |
TIMEREAD |
Time for reading the data to be loaded (for example, when uploading a file to BW Workspace Designer) |
TIMETRANSF |
Time for transforming the data for indexing/processing the asynchronous background jobs |
TIMEFILL |
Time for indexing |
TIMEOPTIMIZE |
Time for Prepare Optimize |
TIMECOMMIT |
Time of Commit Optimize |
TIMESPARSE |
Check Sparse (only for facts) |
DATAROWS |
Number of loaded records |
TSTPNM |
User |
TIMESTMP |
Start time stamp |
The statistics generate a large data set in the statistics tables. Therefore we recommend that you regularly delete data. Read the section “Manual Deletion of Statistics Data” in Maintenance of Statistics Properties.