Show TOC

OLAP: Aggregated Data Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0TCT_DS01

 

This DataSource contains query runtime statistics for the system. Fields defined by the DataSource are listed in the extraction structure.

Technical Data

Application Component

TCT

Available as of Release

Shipment

Starting release of the BI system

Content Versions

7.0

RemoteCube-Capable

Yes

Delta-Capable

Yes

Extraction from Archives

No

Verifiable

No

Prerequisites

To collect statistics for BI applications or BI application objects (query, workbook, Web template, and so on), BI statistics must be switched ‘ON’ in transaction RSDDSTAT.

Data Modeling

Delta Update

The DataSource has a function module extractor RSTC_BIRS_OLAP_AGGREGATED_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

INFOPROV

InfoProvider (if applicable). RSDDSTATHEADER INFOPROV

RSDDSTATHEADER

INFOPROV

INFOPROV_TYPE

Type of InfoProvider (if applicable)

STATLEVEL L

Level of detail with which the statistics are monitored

RSDDSTATHEADER

STATLEVE

OBJPROP

Properties of the statistics object (query, template, and so on)

RSDDSTATHEADER

OBJPROP

CALDAY Calendar day of recording RSDDSTATINFO CALDAY

Calendar day of recording

RSDDSTATINFO

CALDAY

STARTTIME

Starting time

RSDDSTATINFO

STARTTIME

STEPUID

Statistics step

RSDDSTATHEADER

STEPUID

STEPTP

OLAP statistics: step type (ODBO, BEX, and so on)

RSDDSTATINFO

STEPTP

STEPCNT

Navigation step counter during query execution

RSDDSTATINFO

STEPCNT

UNAME

User name

RSDDSTATINFO

UNAME

UTIME

BI statistics time

RSDDSTATINFO

UTIME

LOGSYS

Source system

OBJECT

Template (if available or used)

OBJECT_TYPE

Type of object

SUB_OBJECT

Query runtime object, for example, Query or View

SUB_OBJECT_TYPE

Type of subobject

HANDLEID

Internal ID or counter of the query or template runtime object

RSDDSTATEVDATA

HANDLEID

HANDLETP

Type of the runtime object

RSDDSTATEVDATA

HANDLETP

EVENTID

ID (NUMC9) of the event maintained in table RSDDSTATEVENTS

RSDDSTATEVDATA

EVENTID

EVTIME

Time measured for the event (if applicable).

RSDDSTATEVDATA

EVTIME

EVCOUNT

Counter for this event (if applicable).

RSDDSTATEVDATA

EVCOUNT

RUNTIME

Runtime

RSDDSTATINFO

RUNTIME

HOUR_SLOT

Indicator for the hour when the execution took place

TIME_FE

Duration for frontend

TIME_OLAP

Duration for OLAP

TIME_DM

Duration for Data Manager

TIME_PLAN

Duration for planning

TIME_OVERALL

Total duration for object or subobject

QUERY_COUNTER

Constant set to 1 for every BI application object

WEBTEMPLATE_COUNTER

Constant set to 1 for every BI application

DBTRANS

RSDDSTATEVDATA

EVCOUNT

DBSEL

RSDDSTATEVDATA

EVCOUNT

Extractor Logic

All the fields mentioned in the 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)

  • InfoProvider type (depending on the InfoProvider)

  • Object (front-end object (Web template or workbook) depending on handle type

  • Object type (Web template or workbook) depending on handle type or object

  • Subobject (query or view)

  • Subobject type (Web template or workbook) depending on handle type or object

  • LOGSYS

  • HOUR_SLOT

  • TIME_FE

  • TIME_OLAP

  • TIME_DM

  • TIME_PLAN

  • TIME_NOTASSIGNED

  • TIME_OVERALL

  • DBTRANS

  • DBSEL