Query Runtime Statistics (Previously OLAP Statistics) (Changed) 

Technical data

Function is	Changed
For Release	Software components ●      Component: SAP NetWeaver ●      Release 7.0
Assignment to Application Component	BW-BEX-OT
Country Setting	Valid for all countries

Use

With the new architecture for BI reporting, collection of statistics for query runtime analysis was enhanced or changed. The parallelization in the data manager area (during data read) that is being used more frequently has led to splitting the previous "OLAP" statistics data into "data manager" data (such as database access times, RFC times) and front-end and OLAP times. The statistics data is collected in separate tables, but it can be combined using the InfoProvider for the technical content.

The information as to whether statistic data is collected for an object no longer depends on the InfoProvider. Instead it depends on those objects for which the data is collected, which means on a query, a workbook or a Web template. The associated settings are maintained in the RSDDSTAT transaction.

Effects on Existing Data

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

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

Effects on Customizing

The Collect Statistics setting is obsolete. Instead you have to determine whether and at which granularity you wish to display the statistics data for the individual objects (query, workbook, Web template). In the RSDDSTAT transaction, you can turn the statistics on and off for all queries for an InfoProvider. The maintenance of the settings (such as before) from the Data Warehousing Workbench can be reached using Tools  ® BW Statistics.