Mean Time per Query (SAP Library - BW Statistics MultiProvider Queries)

Mean Time per Query

Technical name: 0BWTC_C10_Q507

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

For the queries examined, this query only contains the key figure Average Execution Time per Navigation. This enables you to have a quick overview.

If large amounts of time occur, you can use the following BW statistics queries, for example, for a closer analysis:

Runtime Query (0BWTC_C10_Q014)

Mean Time per Query (0BWTC_C10_Q021)

Filters

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0CALDAY	Calendar Day restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS
0TCTOLAPACT	OLAP Processor Method restricted to the following fixed values: = ODBO (5) = Print in Batch (2) = Execute Query/ Navigation Step (1)
0TCTOBJVERS	Object Version restricted to fixed value = A

Free Characteristics

InfoObject	Description
0TCTSYSID	BW System
0TCTUSERNM	User restricted to characteristic variable user 0TCTUSES
0TCTIFCUBE	InfoCube restricted to characteristic variable InfoCube 0TCTCUBS
0TCTAGGREG	Aggregate

Variables Used

Variable	Description
0TCTDATS	Tech.Cont.: Time period, for which data is selected
0TCTUSES	User
0TCTCUBS	InfoCube

Rows

InfoObject

Description of the InfoObject (Restriction or Calculation Formula)

0TCTQUERY

Structure link Query

restricted to characteristic value variable query 0TCTQUYS

Columns

InfoObject

Description of the InfoObject (Restriction or Calculation Formula)

Average execution time per navigation, the average total time (OLAP)

calculated from the key figures Structure link total time (OLAP) (0TCTTOLAPAL) and number of navigations (0TCTNAVCTR) according to the formula 'total time (OLAP)' / number of navigations'

Example

This graphic is explained in the accompanying text