Data Manager: Detailed Data

DataSource Transactional Data: 0TCT_DS03

This DataSource contains details of query runtime statistics at Data Manager level. Fields that are provided by this DataSource are listed in the extraction structure.

Technical Data

Application Component	TCT
Available as of Release	Starting release of the OLTP system
Shipment	Starting release of the BW system
Content Versions	7.0
RemoteCube-Capable	Yes
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Delta Update

The DataSource has a function module extractor RSTC_BIRS_DM_DETAILED_DATA that internally handles the delta. DB table ROOSGENDLM stores the delta pointer for each executed DataSource. The delta pointer is extracted from this table for subsequent delta extractions. The corresponding delta data is extracted from different DB tables.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`DMUID`	UID of dimension	`RSDDSTATDM`	`DMUID`
`STEPUID`	Statistics step	`RSDDSTATINFO`	`STEPUID`
`HANDLEID`	Internal ID or counter of query or template runtime object	`RSDDSTATEVDATA`	`HANDLEID`
`HANDLETP`	Type of runtime object	`RSDDSTATEVDATA`	`HANDLETP`
`INFOPROV`	InfoProvider accessed	`RSDDSTATEVDATA`	`INFOPROV`
`IPTYPE`	Type of InfoProvider
`PARTPROV`	PartProvider accessed	`RSDDSTATEVDATA`	`PARTPROV`
`PPTYPE`	Type of PartProvider
`AGGREGATE`	Aggregate	`RSDDSTATDM`	`AGGREGATE`
`ACCESSCNT DM`	Statistics: Access counter for DataManager	`RSDDSTATDM`	`ACCESSCNT`
`WP_ID`	Process ID of work process	`RSDDSTATDM`	`WP_ID`
`OBJNAME`	Query runtime object, for example query, template, workbook name, name of a Web item	`RSDDSTATHEADER`	`OBJNAME`
`OBJECT_TYPE`	Type of object
`TABLTP`	Type of table	`RSDDSTATDM`	`TABLTP`
`UNAME`	User name	`RSDDSTATINFO`	`UNAME`
`UTIME`	BI statistics time	`RSDDSTATINFO`	`UTIME`
`LOGSYS`	Source system		`LOGSYS`
`DBSEL`	Selected datasets	`RSDDSTATDM`	`DBSEL`
`DBTRANS`	Transferred datasets	`RSDDSTATDM`	`DBTRANS`
`TIMEDMPOST`		`RSDDSTATDM`	`Post-processing time TIMEDMPOST`
`TIMEDMPREP`	Preprocessing time	`RSDDSTATDM`	`TIMEDMPREP`
`TIMEHIERARCHY`	Time to create hierarchy	`RSDDSTATDM`	`TIMEHIERARCHY`
`TIMENAVATTR`	Time to evaluate navigation attributes	`RSDDSTATDM`	`TIMENAVATTR`
`TIMEREAD`	Time to read database	`RSDDSTATDM`	`TIMEREAD`
`TIMESID`	Time to evaluate SID	`RSDDSTATDM`	`TIMESID`
`STARTTIME`	Starting time	`RSDDSTATINFO`	`STARTTIME`
`CALDAY`	Calendar day of recording	`RSDDSTATINFO`	`CALDAY`

Extractor Logic

All the fields in the above table are extracted directly from the table RSDDSTAT_DM. RSDDSTAT_DM is a view built on the tables RSDDSTATHEADER, RSDDSTATINFO, and RSDDSTATDM.

The following information is added during extraction:

System name

Object type
Type of InfoProvider
Type of PartProvider