BI Runtime Statistics 

Description

Using the query runtime statistics, you can determine how much time the execution of certain user actions in the front end and in the analytic engine require. The system records the performance-critical parts of the processing (statistics events). It calculates the net times by calculating the runtime of an event using the difference between the start and end times (minus the times for other events called from within the event).

The statistics data is stored in various tables. They are combined with the InfoProviders for the technical content.

General Practices with Migration

Due to the changes in the OLAP and front-end architecture, previously collected statistics data can only be partially compared with the new data.

Since the structure of the new tables differs greatly from that of the RSDDSTAT table, data can no longer be provided for InfoProviders based on previous data (table RSDDSTAT).

The Collect Statistics setting for InfoProviders is obsolete. Instead, you must specify for each of the individual objects (query, workbook, Web template) whether and at which level you want to record the statistics data. In the RSDDSTAT transaction, you can switch the statistics on and off for all queries for an InfoProvider. As before, you can navigate to the maintenance for the settings from the Data Warehousing Workbench by choosing Tools ® BW Statistics.