(DI-2208) Collector for BW Query Runtimes

This collector monitors the state of BW queries and reports queries that ends up in error or are too long-running /DVD/MON_BW_CL_COL_QUERY_RT.

Default KPIs delivered with this collector

The following default KPIs are delivered with this collector:

KPI name

Description

Unit

Detail table

KPI name

Description

Unit

Detail table

BW_QUERY_ERROR

BW: Number of erroneous Queries

Number

Yes

BW_QUERY_LONG_RUN

BW: Number of long-running Queries

Number

Yes

BW_QUERY_RUNTIME

BW: Number of executed Queries

Number

Yes

Parameters

The following parameters are used for this collector:

Parameter name

Description

Parameter name

Description

TIME_PERIOD_IN_SECS

Default 3600 seconds (1 hour). Defines how far back in time should query data be processed.

Detail table

The collector provides detail tables BW Queries Runtime Collector. The technical name of the detail table is /DVD/MON_BW_PCE. It contains queries that are too long-running or are in an error state.

Technical name

Description

Technical name

Description

QUERY_NAME

Name (ID) of a reporting component

STARTTIME

BW Query Start Timestamp

SESSIONUID

Session ID

STEPUID

Step ID

STEPTP

OLAP Statistics: Step Type (ODBO, BEX, etc.)

USER_NAME

User Name

USER_GROUP

User group in user master maintenance

INFOPROVIDER

InfoProvider

INFOPROVIDER_TEXT

Long description

INFOAREA

InfoArea

INFOAREA_TEXT

Long description

DATA_MANAGER

BW Query: Data Manager Runtime

OLAPS_AUTH

BW Query: OLAP Authorization Runtime

OLAPS_CACHE

BW Query: OLAP Cache Runtime

OLAPS_OLAP

BW Query: OLAP Runtime

TOTAL_RUNTIME

BW Query: Total Runtime

DBTRANS

Total Number of Transported Records

DBSEL

Total Number of Read Records

WHERE_CLAUSE

WHERE clause for the filter of the BW query

STATUS

Query Status

ERROR_TEXT

Error Text