(DI-2308) In which processing OLAP processing block are Extended Query Statistics gathered?

Owned by DVD ROBOT
Aug 14, 2023
1 min read

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

Enhancement for gathering statistics is called right before OLAP event 3110. The basic event structure in RSDDSTAT* tables for a query where statistics are gathered should look like:

  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 structure element selection or a restricted key figure.)

In the case of execution of query from the cache, statistics are not gathered. Such query execution will miss in RSDDSTAT* tables following OLAP events:

  • Event: 9000 (Data Manager)
  • Event: 3110 (Data Manager Call Back)