This section explains the mapping details for the migration of BI statistics from SAP BW 3.x to SAP NetWeaver 7.0.
In SAP BW 3.x, all the statistics are contained directly in the key figures in the BI statistics tables. These key figures are then loaded 1:1 into the technical content InfoCubes. 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.
All the BI statistics in SAP BW 3.x are logged in a single table, RSDDSTAT.
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:
· RSDDSTATHEADER
· RSDDSTATINFO
· RSDDSTATEVDATA
· RSDDSTATDM
BI Statistics Mapping
SAP BW 3.x |
SAP NetWeaver |
||||
Table Field |
Technical Name of InfoObject |
Location in InfoCube |
Table Field |
Technical Name of InfoObject |
Location in InfoCube |
SESSIONUID |
0TCTSESUID |
Front-end session (GUID) |
RSDDSTAT_OLAP-SESSIONUID |
0TCT_MC01 |
0TCTSESUID |
NAVSTEPUID |
0TCTNAVUID |
Navigation step (GUID) |
RSDDSTAT_OLAP-STEPUID |
0TCT_MC01 |
0TCTSTEPUID |
INFOCUBE |
0TCTIFCUBE |
InfoCube |
RSDDSTAT_OLAP-INFOPROV |
0TCT_MC01 |
0TCTIFPROV |
HANDLE |
|
|
RSDDSTAT_OLAP-HANDLETP |
Used in key figure assignment for 0TCT_C01 0TCT_MC02 |
0TCTHANDLTP |
QUERYID |
0TCTQUERY |
Query |
RSDDSTAT_OLAP-OBJNAME if HANDLETP = OLAP |
0TCT_MC01 |
0TCTBISBOBJ where 0TCTBISOTYP = 'ELEM' or 'QVIW' |
UNAME |
0TCTUSERNM |
User |
RSDDSTAT_OLAP-UNAME |
0TCTUSERNM |
|
QAGGRUSED |
Not available |
Not available |
RSDDSTAT_DM-AGGREGATE |
0TCT_MC03 |
0TCTAGPROV |
OLAPMODE |
0TCTOLAPACT |
OLAP processor method |
Replaced with RSDDSTAT_OLAP-STEPTP and RSDDSTAT_OLAP-EVENTID = '9001' for capturing InfoProvider read access through the Data Manager Interface |
|
|
DBSELTP |
0TCTDBSELTP |
Type of data read |
RSDDSTAT_DM-ACCESSTP |
Available in DataSource but not in technical content InfoProviders |
|
QRUNTIMECATEGORY |
0TCTRTIMEC |
Runtime category (1, 2, 3, ... 10, 20, 30, ... seconds) |
RSDDSTAT_OLAP-RUNTIME |
0TCT_MC01 |
0TCTRTIMEC |
QNAVSTEP |
0TCTNAVSTP |
Navigation step (current numbers within the session) |
RSDDSTAT_OLAP-STEPCNT |
|
|
QNUMOLAPREADS |
0TCTDBSCTR |
Number of database selects |
RSDDSTAT_DM-ACCESSCNT |
0TCTDMCNT |
|
QDBSEL |
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 |
QDBTRANS |
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 |
QNUMCELLS |
0TCTNCELLS |
Cells transferred to the front end |
= RSDDSTAT_OLAP-EVENTCNT for EVENTID = '000015010' |
0TCT_C02-0TCTSTATCNT for 0TCTSTATEVT = '000015010' |
|
QNUMRANGES |
0TCTNRANGS |
Formatting transferred to the front end |
= RSDDSTAT_OLAP-EVENTCNT for EVENTID = '000015011'? |
0TCT_C02-0TCTSTATCNT for 0TCTSTATEVT = '000015011' |
|
QTIMEOLAPINIT |
0TCTTOLINI |
Time, OLAP Processor initialization |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '000003000', '000003010' and '000003500' |
0TCT_MC02: 0TCTSTATTIM for 0TCTSTATEVT = '000003000', '000003010' and '000003500' |
|
QTIMEOLAP |
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 (see RSDDSTAT_OLAP_0TCT_C01.jpg) |
0TCT_MC01 |
0TCTTMEOLAP |
|
QTIMEDB |
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 |
QTIMEVARDP |
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 |
QTIMEUSER |
0TCTTNAVIG |
Time between navigation steps |
RSDDSTAT_OLAP-EVTIME for EVENTID = '000000001' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000000001' |
QTIMECLIENT |
0TCTTFRONT |
Time, front end |
Sum of various EVENTIDs in RSDDSTAT_OLAP in extraction to 0TCT_MC01 (see RSDDSTAT_OLAP_0TCT_C01.jpg) |
0TCT_MC01 |
0TCTTIMEFE |
TIMECHAVLREAD |
0TCTTRDMDA |
Time, feeding texts, or master data |
RSDDSTAT_OLAP-EVTIME for EVENTID = '000003210' and '000003900' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000003210' and '000003900' |
TIMEAUTHCHECK |
0TCTTAUTH |
Time, authorization check |
RSDDSTAT_OLAP-EVTIME for EVENTID = '000004xxx' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000003210' and '000004xxx' |
TALERTMON |
|
|
RSDDSTAT_OLAP-EVTIME for EVENTID = '000019970' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '000003210' and '000019970' |
TIMEREST |
0TCTTREST |
Time that the system was unable to assign |
mainly times record with RSDDSTAT_OLAP-HANDLETP = DFLT |
0TCT_MC01 |
0TCTTIMENA |
ODBOT |
0TCTTODBOAL |
Time, feneral ODBO |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
ODBOTINIT |
0TCTTODBOIN |
Time, ODBO: Initialization |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
ODBOTPREPAXES |
0TCTTODBOAX |
Time, ODBO: Axes Preparation |
RSDDSTAT_OLAP- EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02 |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
ODBOTREQDATA |
0TCTTODBORE |
Time, ODBO: Data Requests |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
ODBOTPREDTST |
0TCTTODBODA |
Time, ODBO: Data Records Preparation |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
ODBOTFLATENING |
0TCTTODBOFL |
Time, ODBO: Conversion into Flat Table Form |
RSDDSTAT_OLAP-EVTIME for EVENTIDs = '0000400xx' |
0TCT_MC02: |
0TCTSTATTIM for 0TCTSTATEVT = '0000400xx' |
DMTDBBASIC |
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' |
|
DMTDBREMOTE |
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 = VR Virtual InfoProvider Based on BAPI, VS Virtual InfoProvider Based on DTP/3.x InfoSource and VC Virtual InfoProvider Based on Function Module" |
|
DMTDBODS |
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' |
|
WEBTTEMPPREP |
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' |
WEBTRENDER |
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' |
The following table lists the changes in the technical names of the InfoObjects:
Mapping Details of InfoObjects
SAP BW 3.x |
NetWeaver 2004s |
|
Technical Name of InfoObject |
Location in Table |
Technical Name of InfoObject |
0TCTOLAPRD |
OLAP Reading On / Off |
Not available |
0TCTSYSID |
BW System |
0TCTSYSID |
0TCTOBJVERS |
Object Version (for example, 0TCTIFCUBE) |
0TCTOBJVERS |
0TIME |
Time |
0TCTUTIME |
0CALDAY |
Calendar Day |
0CALDAY |
0TCTNAVCTR |
Number of Navigations |
0TCT_C01: replaced with 0TCTQUCOUN and 0TCTWTCOUN |
0TCTSESCTR |
Number of Front-end Sessions |
0TCT_C01: replaced with 0TCTQUCOUN and 0TCTWTCOUN |
0TCTNOLAPAL |
Total (OLAP) |
|
0TCTNOLARD |
Read Cycles (Fetch) OLAP Processor |
Not available |
0TCTNTEXTS |
Number of Texts Read |
Not available |
0TCTSDATE |
Start Date |
0CALDAY |
0TCTSTAUIK |
Frequency |
Not available |
0TCTSTIMEK |
Start Time |
0TCTUTIME |
Fields and InfoObjects in SAP BW 3.x that are not included in this table are either obsolete or not available in SAP NetWeaver 7.0.