OLAP: Detailed Data

DataSource Transactional Data: 0TCT_DS02

DataSource OLAP: Detailed data provides detailed data for the query runtime statistics. Fields defined by the 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_OLAP_DETAILED_DATA that internally handles the delta. DB table ROOSGENDLM stores the delta pointer for each executed DataSource. For subsequent delta extractions, the delta pointer is extracted from this table. 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
`SESSIONUID`	Statistics session	`RSDDSTATHEADER`	`SESSIONUID`
`STEPUID`	Statistics step	`RSDDSTATINFO`	`STEPUID`
`STEPTP`	OLAP statistics: step type (ODBO, BEX, and so on)	`RSDDSTATINFO`	`STEPTP`
`STEPCNT`	Navigation step counter during query execution	`RSDDSTATINFO`	`STEPCNT`
`HANDLEID`	Internal ID or counter of query or template runtime object	`RSDDSTATEVDATA`	`HANDLEID`
`HANDLETP`	Type of runtime object.	`RSDDSTATEVDATA`	`HANDLETP`
`EVENTID`	ID (NUMC9) of event maintained in table RSDDSTATEVENTS	`RSDDSTATEVDATA`	`EVENTID`
`INFOPROV`	InfoProvider (if applicable)	`RSDDSTATHEADER`	`INFOPROV`
`INFOPROV_TYPE`	Type of InfoProvider (if applicable)
`OBJNAME`	Query runtime object, for example, query, template, workbook name, name of a Web item, and so on	`RSDDSTATHEADER`	`OBJNAME`
`OBJPROP`	Properties of statistic object (query, template, and so on)	`RSDDSTATHEADER`	`OBJPROP`
`STATLEVEL`	Level of detail in which statistics are monitored	`RSDDSTATHEADER`	`STATLEVEL`
`UNAME`	User name	`RSDDSTATINFO`	`UNAME`
`UTIME`	BW statistics time	`RSDDSTATINFO`	`UTIME`
`LOGSYS`	Source system		`LOGSYS`
`EVTIME`	Time measured for event (if applicable)	`RSDDSTATEVDATA`
`EVCOUNT`	Counter recorded for event (if applicable)	`RSDDSTATEVDATA`	`EVCOUNT`
`OBJECT_TYPE`	Type of object
`HOUR_SLOT`	Indicator in which hour execution took place
`EVENTIDCNT`	Number of times event was triggered (internal use)	`RSDDSTATEVDATA`	`EVENTIDCNT`
`CALDAY`	Calendar day of recording	`RSDDSTATINFO`	`CALDAY`
`RUNTIME`	Runtime	`RSDDSTATINFO`	`RUNTIME`
`STARTTIME`	Starting time	`RSDDSTATINFO`	`STARTTIME`
`HOUR_SLOT`	Hour slot in which the measurement took place

Extractor Logic

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

The following information is added during extraction:

System name (constant)

Object type, depending on object

Hour slot