FAQ

If database statistics are not recalculated on a regular basis, it is possible that the size of an InfoProvider (consisting of database tables) in the database statistics will not correspond to the real size. The data distribution analysis obtains the size of data partitions from database tables directly via a SELECT statement. However, it also obtains the total InfoProvider size from database statistics, which are not always current. Therefore, the total InfoProvider size in the data distribution analysis can be smaller than sum of its data parts.

Extended query statistics are gathered in the OLAP processing block when the call to the Data Manager is finished.

An enhancement for gathering statistics is called right before the OLAP event 3110. The basic event structure in RSDDSTAT* tables for a query where statistics are gathered must look like this:

1. Event: 19900 (Analyzer server)

   1. Event: 19952 (Query view data access) 

      1. Event: 3100 (Read data)

         1. Statistics collection

         2. Event: 3110 (This event measures the time taken to call the Data Manager and to sort the read data according to the structure element selection or a restricted key figure.)

If the query is executed from the cache, statistics are not gathered. Such a query execution will miss the following OLAP events in RSDDSTAT* tables:

• Event: 9000 (Data Manager)

• Event: 3110 (Data Manager callback)

If the import of transport requests finishes with the error Component version mismatch, you must import the transport request again. To do so, in the Options tab, select the option Ignore Invalid Component Version and click Confirm.