Setup for Additional Statistics Collection for BW Queries

While executing the BW queries on the monitored system, some information related to the monitoring of the executed BW query is not retrospectively available for data collection. For this reason, certain enhancements in the SAP standard exist to handle and store the required information about the BW query during its execution.

  • /DVD/MON_BW_QUERY_ERR: If an error occurs during the BW query execution, this enhancement saves this error to the monitoring table that is then processed by the Collector for BW Query Runtimes.

    • By default, it automatically saves the errors that occurred during BW query execution to be able to monitor the number of erroneous BW Queries.

  • /DVD/MON_BW_QUERY_SELVAR:This enhancement stores the selection variables that were used for the BW query execution. These selection variables are then processed by the Collector for BW Query Runtimes and reported as WHERE clause for BW query into the detail table with name BW query runtime details.

    • By default, the selection variables are not stored in the monitoring table.

To be able to control the additional statistics collection about the executed BW Queries via these monitoring enhancements, the new transaction /DVD/MON_BWQ was created.

NOTE

This is a new setup for BW Queries monitoring that was introduced in the version 2311. Since this version, the Extended Query Statistics (EQS) are not delivered within the monitoring package anymore, but keep in mind that the BW Queries monitoring is still compatible with the EQS. It means that if the EQS was previously installed and configured on the monitored system, the already configured EQS functionality will be used instead of this new setup.

This transaction provides the following settings that can be configured based on your requirements:

  • Save occurred error in the executed BW Query: If this checkbox is selected, the errors occurred during the BW query execution are saved to the relevant monitoring table, and the affected KPI for the number of erroneous BW queries is collected as expected.

    • By default, this checkbox is selected after installing or upgrading the monitoring.

  • Save used selection variables for the executed BW Query: If this checkbox is selected, the selection variables used for the BW query execution are saved to the relevant monitoring table, and the WHERE clause for the BW query is reported as expected in the detail table BW query runtime details. Otherwise, the WHERE clause is not built and reported at all.

    • By default, this checkbox is not selected after installing or upgrading the monitoring.

  • Exclude characteristics for InfoObject(s): Allows you to define a list of excluded InfoObjects that will be ignored while processing and storing the selection variables used for the BW query execution.