(DI-1705) Query Statistics automatic InfoObject exclusion

Owned by Copy Page Tree
Last updated: Jun 29, 2017 by Jan Sliacky (Deactivated)
2 min read

Datavard Insights Query Statistics functionality contains safety feature to minimalize 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 occurences (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 ommit 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 automaticaly excluded InfoObject can be found in list available in program /DVD/QS_CONFIG.

  1. Execute program /DVD/QS_CONFIG through se38 transaction.
  2. Click on "Exclude characteristics" button.
  3. List of all automatically excluded InfoObjects can be observed in displayed table with also numeric value (in seconds) that shows what processing time of the query was reached when 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 value in "Processing time limit" field from default value 1 (in seconds).