(DI-1808) Collector for BW statistics

The collector for BW statistics is named: /DVD/MON_BW_CL_COL_RSDDSTATS

It collects statistical KPIs about BW. The KPIs are defined via KPI definition and input table /DVD/MON_BWSTDEF, which sets extended KPI definition with following fields:

KPI name	Same technical name like in KPI definition
Event ID	OLAP Statistics Event
User name	User name
Step type	OLAP Statistics: Step Type
InfoProvider	InfoProvider
Object name	OLAP Statistik Object Name
DBTRANS	Max No. of Transfered Records
Function	AVG( RUNTIME ) MAX( EVTIME ) COUINT( * )
MIN_HINT	Minimum number of steps to calculate value
DECIMALS	Number of decimals of value for displaying KPI
Change by user	Last change by user [automatically filled]
Change date	Last change date [automatically filled]

The collector provides also detailed output in detail table for relevant KPIs. The detail table is called: BW Failed query on DM - /DVD/MON_BWMISDM with following fields:

Timestamp

System ID

BW Statistics: Day

BW Statistics Time

STEPUID

Internal ID of a Query Runtime Object

Internal Type of Query Runtime Object

OLAP Statistik Object Name

User Name

Some KPIs are provided in standard delivery with collector as examples:

KPI name	Description	Unit
BW_9000DMMISS	Number of queries failing on DM (BWA, DB, HANA)	count
BW_SSQL_ALLNO	SQL-Total number of subqueries	count
BW_SSQL_ALLTIM	SQL-Total time spent on subqueries
BW_SSQL_SQAR	SQL-Average runtime of small subqueries
BW_SSQL_SQLO	SQL-No of small subqueries long running (eg > 10 SEC)	count
BW_SSQL_SQNO	SQL-No of small subqueries	count
BW_SUBQ_ALLNO	nonSQL-Total number of subqueries (BWA or HANA)	count
BW_SUBQ_ALLTIM	nonSQL-Total time spent on subqueries (BWA or HANA)
BW_SUBQ_SQAR	nonSQL-Average runtime of small subqueries (BWA or HANA)
BW_SUBQ_SQLO	nonSQL-No of small subqueries long running (eg>10SEC) eg BWA	count
BW_SUBQ_SQNO	nonSQL-No of small subqueries (BWA or HANA)	count

NOTE: All standard BW statistical KPIs have prefix BW_*