OLAP: Highly Aggregated Data 
DataSource Hierarchy: 0TCT_DSA1
DataSource 0TCT_DSA1 OLAP gives aggregated details of the query runtime statistics of the system. The fields provided by the DataSource are listed in the extract structure (table givend in the next section). The extractor is designed to extract the necessary details.
Technical Data
Application Component | TCT |
|---|---|
Available as of Release | Start release of the OLTP system |
Shipment | Start release of the BW system |
Content Versions | 7.0 |
RemoteCube-Capable | Yes |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Prerequisites
To collect the statistics of the BI application or BI application object, you must set the BI statistics for BI objects to ON (Query, Workbook, WebTemplate, and so on).
This setting must be made in transaction RSDDSTAT.
Data Modeling
Delta Update
The DataSource has a function module extractor “RSTC_BIRS_OLAP_AGGR_DATA_A”. This function module handles the delta internally. Database table ‘ROOSGENDLM’ stores the delta pointer for each executed DataSource. For the next delta extraction, the delta pointer is therefore extracted from this table and the corresponding delta data is extracted from different DB tables.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
INFOPROV |
InfoProvider (if applicable). |
RSDDSTATHEADER |
INFOPROV |
INFOPROV_TYPE |
Type of InfoProvider (if applicable) |
||
CALDAY |
Calendar day of recording |
RSDDSTATINFO |
CALDAY |
STARTTIME |
Start-time |
RSDDSTATINFO |
STARTTIME |
UNAME |
User Name |
RSDDSTATINFO |
UNAME |
LOGSYS |
Source system |
||
Source system |
Template (if available / used) |
||
OBJECT_TYPE |
Type of OBJECT |
||
SUB_OBJECT |
Query run-time object, e.g. Query / View |
||
SUB_OBJECT_TYPE |
Type of SUB_OBJECT |
||
TIME_FE |
Duration front-end |
||
TIME_OLAP |
Duration OLAP |
||
TIME_DM |
Duration DataManager |
||
TIME_PLAN |
Duration Planning |
||
TIME_NOTASSIGNED |
|||
TIME_OVERALL |
Overall of object or subobject |
||
QUERY_COUNTER |
Constant set to 1 for every BI application object |
||
WEBTEMPLATE_COUNTER |
Constant set to 1 for every BI application |
||
INIT_NAV_FLAG |
Flag ( to distinguish init and Navigation) |
Extractor Logic
All the fields that are mentioned in the above table are extracted directly from the table RSDDSTAT_OLAP. RSDDSTAT_OLAP is a view built on the table RSDDSTATHEADER, RSDDSTATINFO and, RSDDSTATEVDATA.
The following information is added during extraction:
System name (constant)
InfoProvider type (in dependance of the InfoProvider)
OBJECT (Front-End object (Webtemplate / Workbook) in dependance of Handlytype)
OBJECT_TYPE (Object type (Webtemplate / Workbook) in dependance of Handlytype / Object)
SUB_OBJECT (Query / View)
SUB_OBJECT_TYPE (Sub-Object type (Webtemplate / Workbook) in dependance of Handlytype / Object)
LOGSYS
TIME_FE
TIME_OLAP
TIME_DM
TIME_PLAN
TIME_NOTASSIGNED
TIME_OVERALL
INIT_NAV_FLAG