In SAP NetWeaver 7.0, all the statistics are recorded by handle types and event IDs and are assigned to aggregated key figures in the technical content InfoCube 0TCT_C01 using this information. This aggregation is done in DataSource 0TCT_C01. The event IDs are generated for each event, providing detailed information about the system performance at a detailed level.
In SAP NetWeaver 7.0, all the BI statistics are retrieved from views RSDDSTAT_OLAP and RSDDSTAT_DM, which are built on the following underlying tables:
BI Statistics Mapping
Technical Name of InfoObject | Location in InfoCube | Table Field | Technical Name of InfoObject | Location in InfoCube |
---|---|---|---|---|
0TCTSESUID |
Front-end session (GUID) |
RSDDSTAT_OLAP-SESSIONUID |
0TCT_MC01 |
0TCTSESUID |
0TCTNAVUID |
Navigation step (GUID) |
RSDDSTAT_OLAP-STEPUID |
0TCT_MC01 |
0TCTSTEPUID |
0TCTIFCUBE |
InfoCube |
RSDDSTAT_OLAP-INFOPROV |
0TCT_MC01 |
0TCTIFPROV |
RSDDSTAT_OLAP-HANDLETP |
Used in key figure assignment for 0TCT_C01 0TCT_MC02 |
0TCTHANDLTP |
||
0TCTQUERY |
Query |
RSDDSTAT_OLAP-OBJNAME if HANDLETP = OLAP |
0TCT_MC01 |
0TCTBISBOBJ where 0TCTBISOTYP = 'ELEM' or 'QVIW' |
0TCTUSERNM |
User |
RSDDSTAT_OLAP-UNAME |
0TCTUSERNM |
|
Not available |
Not available |
RSDDSTAT_DM-AGGREGATE |
0TCT_MC03 |
0TCTAGPROV |
0TCTOLAPACT |
OLAP processor method |
Replaced with RSDDSTAT_OLAP-STEPTP and RSDDSTAT_OLAP-EVENTID = '9001' for capturing InfoProvider read access through the Data Manager Interface |
||
0TCTDBSELTP |
Type of data read |
RSDDSTAT_DM-ACCESSTP |
Available in DataSource but not in technical content InfoProviders |
|
0TCTRTIMEC |
Runtime category (1, 2, 3, ... 10, 20, 30, ... seconds) |
RSDDSTAT_OLAP-RUNTIME |
0TCT_MC01 |
0TCTRTIMEC |
0TCTNAVSTP |
Navigation step (current numbers within the session) |
RSDDSTAT_OLAP-STEPCNT |
||
0TCTDBSCTR |
Number of database selects |
RSDDSTAT_DM-ACCESSCNT |
0TCTDMCNT |
|
0TCTNDBSEL |
Records selected on the database |
For all queries: = RSDDSTAT_DM-DBSEL (statistics detail level must be = 2) only for queries selecting from single InfoProvider = RSDDSTAT_OLAP-EVCOUNT for EVENTID = '000009011' |
For all queries: 0TCT_MC03: 0TCTNDBSEL (statistics detail level must be = 2) only for queries selecting from single InfoProvider 0TCT_MC01 |
0TCT_DBSEL |
0TCTNDBTRA |
Records transferred from the database to the server |
= RSDDSTAT_DM-DBTRANS only for queries selecting from single InfoProvider = RSDDSTAT_OLAP-EVCOUNT for EVENTID = '000009010' |
for all queries: 0TCT_MC03: 0TCTNDBTRA (statistics detail level must be = 2) only for queries selecting from single InfoProvider 0TCT_MC01 |
0TCT_DBTRA |
0TCTNCELLS |
Cells transferred to the front end |
= RSDDSTAT_OLAP-EVENTCNT for EVENTID = '000015010' |
0TCT_C02-0TCTSTATCNT for 0TCTSTATEVT = '000015010' |
|
0TCTNRANGS |
Formatting transferred to the front end |
= RSDDSTAT_OLAP-EVENTCNT for EVENTID = '000015011'? |
0TCT_C02-0TCTSTATCNT for 0TCTSTATEVT = '000015011' |
|
0TCTTOLINI |
Time, OLAP Processor initialization |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '000003000', '000003010' and '000003500' |
0TCT_MC02: 0TCTSTATTIM for 0TCTSTATEVT = '000003000', '000003010' and '000003500' |
|
0TCTTOLAP |
Time, OLAP Processor |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '000003xxx' |
0TCT_MC02: 0TCTSTATTIM for 0TCTSTATEVT = '000003xxx' |
|
0TCTTOLAPAL |
Total time (OLAP) |
Sum of various EVENTIDs in RSDDSTAT_OLAP in extraction to 0TCT_MC01 |
0TCT_MC01 |
0TCTTMEOLAP |
0TCTTDBRD |
Time, reading on the database |
For all queries: = RSDDSTAT_DM-TIMEREAD (statistics detail level must be = 2) only for queries selecting from single InfoProvider = RSDDSTAT_OLAP-EVTIME for EVENTID = '000009000' |
For all queries: 0TCT_MC03: 0TCTTDMREAD (statistics detail level must be = 2) only for queries selecting from single InfoProvider 0TCT_MC01 |
0TCTTIMEDM |
0TCTTVARDP |
Time, input variables |
Variable popups are not recorded separately as of note 981686. They are recorded under HANDLETP = DFLT with EVENTID = 1 |
Part of 0TCT_MC01 |
0TCTTIMENA |
0TCTTNAVIG |
Time between navigation steps |
RSDDSTAT_OLAP-EVTIME for EVENTID = '000000001' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000000001' |
0TCTTFRONT |
Time, front end |
Sum of various EVENTIDs in RSDDSTAT_OLAP in extraction to 0TCT_MC01 |
0TCT_MC01 |
0TCTTIMEFE |
0TCTTRDMDA |
Time, feeding texts, or master data |
RSDDSTAT_OLAP-EVTIME for EVENTID = '000003210' and '000003900' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000003210' and '000003900' |
0TCTTAUTH |
Time, authorization check |
RSDDSTAT_OLAP-EVTIME for EVENTID = '000004xxx' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000003210' and '000004xxx' |
RSDDSTAT_OLAP-EVTIME for EVENTID = '000019970' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000003210' and '000019970' |
||
0TCTTREST |
Time that the system was unable to assign |
mainly times record with RSDDSTAT_OLAP-HANDLETP = DFLT |
0TCT_MC01 |
0TCTTIMENA |
0TCTTODBOAL |
Time, general ODBO |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
0TCTTODBOIN |
Time, ODBO: Initialization |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
0TCTTODBOAX |
Time, ODBO: Axes Preparation |
RSDDSTAT_OLAP- EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
0TCTTODBORE |
Time, ODBO: Data Requests |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
0TCTTODBODA |
Time, ODBO: Data Records Preparation |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
0TCTTODBOFL |
Time, ODBO: Conversion into Flat Table Form |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
0TCTTDMDBB |
Time, Data Manager Reading from BasicCube |
See entry for QTIMEDB, specific analysis of InfoProvider types only possible using InfoProvider name |
See entry for QTIMEDB, where 0TCTIFTYPE (0TCT_MC01) = 'CUBE' or 0TCTPARTYPE (0TCT_MC03) = 'CUBE' |
|
0TCTTDMDBR |
Time, Data Manager Reading from RemoteCube |
See entry for QTIMEDB, specific analysis of InfoProvider types only possible using InfoProvider name |
Filter on 0TCTIFTYPE = CUBE and for characteristic 0TCTIFPROV (InfoProviders used) filter on attribute 0TCTBWOSTYP =
|
|
0TCTTDMDBO Time |
Data Manager Reading from ODS |
See entry for QTIMEDB, specific analysis of InfoProvider types only possible using InfoProvider name |
See entry for QTIMEDB, where 0TCTIFTYPE (0TCT_MC01) = 'ODSO' or 0TCTPARTYPE (0TCT_MC03) = 'ODSO' |
|
Not available |
Not available |
For BEx Web 3.x: RSDDSTAT_OLAP-EVTIME for EVENTID = '000019910' for BEx Web 2004s: RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000126xx' |
For BEx Web 3.x: 0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '000019910' for BEx Web 2004s: 0TCT_MC02: 0TCTSTATTIM for 0TCTSTATEVTs = '0000126xx' |
Not available |
Not available |
For BEx Web 3.x: RSDDSTAT_OLAP-EVTIME for EVENTID = '000019911' for BEx Web 2004s: RSDDSTAT_OLAP-EVTIME for EVENTIDs = '00001260x' |
For BEx Web 3.x: 0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000019911' for BEx Web 2004s: 0TCT_MC02: 0TCTSTATTIM for 0TCTSTATEVTs = '00001260x' |