Average Times and Records (Navigation)
Technical name: 0BWTC_C10_S002
InfoCube component: BW statistics (0BWTC_C10)
Use
This structure is used in the following queries for BW statistics:
The structure contains the following elements:
Element |
Selection/Formula |
Number of Navigations
0TCTNAVCTR |
from key figure |
Total Time (OLAP)
0TCTTOLAPAL |
from key figure |
Average total time (OLAP) |
'Total Time (OLAP)' / 'Number of Navigations' |
Average time, initialization OLAP |
'Time, OLAP Processor Initialization' / 'Number of Navigations' |
Average time, OLAP processor |
'Time, OLAP Processor' / 'Number of Navigations' |
Average time, reading database |
'Time, Reading to the Database' / 'Number of Navigations' |
Average time, frontend |
'Time, Frontend' / 'Number of Navigations' |
Average time, authorization check |
'Time, Authorization Check' / 'Number of Navigations' |
Average time, reading texts/master data |
'Time, Reading Texts/Master Data' / 'Number of Navigations' |
Average number of records selected from the database |
'Records Selected from the Database' / 'Number of Navigations' |
Average number of records transferred from the database |
'Records Transferred from the Database' / 'Number of Navigations' |
Average number of cells transferred to the frontend |
'Cells Transferred to the Frontend' / 'Number of Navigations' |
Average number of formatting transferred to the frontend |
'Formatting Transferred to the Frontend' / 'Number of Navigations' |
Average number of texts read |
'Number of Texts Read' / 'Number of Navigations' |
The key figures determined are calculated according to each formula specified (division by the Number of Navigations 0TCTNAVCTR key figure) from the following key figures:
The individual key figures are contained in the
Times and Data Records (OLAP) (0BWTC_C10_S010) structure.