(DI-2005) Query Statistics Automatic InfoObject Exclusion

Owned by SNP
Last updated: Jul 01, 2020 by Marian Vidra
2 min read

Datavard Insights Query Statistics functionality contains the safety feature to minimize the impact on reporting performance in customer system. If processing of query filters during query execution exceeds set time, threshold following functionality is triggered:

  • Query filters are processed and InfoObject with most occurrences (e.g., 0MATERIAL with 10 000 I EQ XXX filters) is automatically added to the list of excluded InfoObjects.
  • Every other execution of Datavard Insights Query Statistics collection will omit filters on such InfoObjects (globally) therefore decreasing processing time (impact on reporting performance) and space needed (excluded filter values are not saved in DB).
  • Standard time characteristics (0CALYEAR, 0CALMONTH, 0CALWEEK, 0CALDAY, 0FISCYEAR, 0FISCPER) are never excluded.

Each automatically excluded InfoObject can be found in the list available in program /DVD/QS_CONFIG.

  1. Execute program /DVD/QS_CONFIG through SE38 transaction or use transaction /DVD/QS_CONF.
  2. Click on "Exclude characteristics" button.
  3. List of all automatically excluded InfoObjects can be observed in below displayed table with also numeric value (in seconds) that shows what processing time of the query was reached when this exclusion happened.  


  4. Automatically excluded InfoObjects are present in select option with other user defined exclusion selections.



  5. User can change processing time limit that triggers exclusion by changing the value in "Processing time limit" field from default value 1 (in seconds).