Mean Time per Query 
Technical name: 0BWTC_C10_Q021
Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)
Use
For the BEx queries examined, this query shows the key figures contained in the Average Times and Records (Navigation) 0BWTC_C10_S002 structure.
The BW statistics query OLAP Use per Query (0BWTC_C10_Q012) contains the underlying key figures for these average values.
Average values are calculated according to the formula 'Key Figure' (for the time or for the records) divided by the key figure value for Number of Navigations (0TCTNAVCTR). Because of this, the values for this BW statistics query then agree with those for the OLAP Use per Query query, if the Number of Navigations key figure has the value "1".
Filters
|
InfoObject |
Description of the InfoObject (Restriction or Calculation Formula) |
|
0CALDAY |
restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS |
|
0TCTOLAPACT |
restricted to the following fixed values: = ODBO (5) = Print in Batch (2) = Execute Query/ Navigation Step (1) |
|
0TCTOBJVERS |
restricted to fixed value = A |
Calendar
DayFree Characteristics
|
InfoObject |
Description |
|
0TCTSYSID |
BW system |
|
0TCTUSERNM |
restricted to characteristic variable user 0TCTUSES |
|
0TCTIFCUBE |
restricted to characteristic variable InfoCube 0TCTCUBS |
|
0TCTAGGREG |
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 |
restricted to characteristic value variable query 0TCTQUYS |
Columns
|
InfoObject |
Description of the InfoObject (Restriction or Calculation Formula) |
|
0BWTC_C10_S002 |