Show TOC

Front-End and OLAP Statistics (Aggregated) Locate this document in the navigation structure

InfoCube InfoCube: 0TCT_C01

 

InfoCube 0TCT_C01 is a standard InfoCube that contains front-end and query runtime statistics (aggregated).

This InfoCube is used for monitors that display all the aggregated values of the front-end and query runtime for BI applications, BI application objects, and InfoProviders on the portal. It contains the average query runtimes and details for predefined runtime categories. You can monitor query activity and drill down to the navigation steps.

Data Modeling

Requires

Object Type

Name

Technical Name

InfoObject

Calendar Day

0CALDAY

InfoObject

Calendar Year/Month

0CALMONTH

InfoObject

Calendar Year/Quarter

0CALQUARTER

InfoObject

Calendar Year/Week

0CALWEEK

InfoObject

Calendar Year

0CALYEAR

InfoObject

Change Run ID

0CHNGID

InfoObject

Record type

0RECORDTP

InfoObject

Request ID

0REQUID

InfoObject

BI Application

0TCTBIOBJCT

InfoObject

Type of BI Application

0TCTBIOTYPE

InfoObject

BI Application Object

0TCTBISBOBJ

InfoObject

Type of BI Application Object

0TCTBISOTYP

InfoObject

Database Records Selected

0TCTDBSEL

InfoObject

Number of Records Transferred to OLAP Processor

0TCTDBTRANS

InfoObject

Handle ID, OLAP Statistics

0TCTHANDLID

InfoObject

Hour Slot in which the measurement took place

0TCTHOURSLT

InfoObject

InfoProviders Used

0TCTIFPROV

InfoObject

InfoProvider Type

0TCTIFTYPE

InfoObject

Properties of the monitored object

0TCTOBJPROP

InfoObject

Object Version

0TCTOBJVERS

InfoObject

Counter for BI Application Objects

0TCTQUCOUNT

InfoObject

Validity Period Category

0TCTRTIMEC

InfoObject

Frontend session

0TCTSESUID

InfoObject

Detail Level, OLAP Statistics

0TCTSTATLEV

InfoObject

Step Counter During Query Execution

0TCTSTEPCNT

InfoObject

Step Type, OLAP Statistics

0TCTSTEPTP

InfoObject

Query (Navigation) Step

0TCTSTEPUID

InfoObject

BW System

0TCTSYSID

InfoObject

Total time

0TCTTIMEALL

InfoObject

Time recorded for DataManager

0TCTTIMEDM

InfoObject

Time recorded on front-end side

0TCTTIMEFE

InfoObject

Time not assigned to front-end, OLAP or DataManager

0TCTTIMENA

InfoObject

UTC Time Stamp

0TCTTIMSTMP

InfoObject

Time recorded for OLAP

0TCTTMEOLAP

InfoObject

Time recorded for Planning

0TCTTMEPLAN

InfoObject

User

0TCTUSERNM

InfoObject

Time, Query Start (OLAP Statistics)

0TCTUTIME

InfoObject

Counter for BI Applications

0TCTWTCOUNT

InfoObject

Weekday

0WEEKDAY1