Front End and OLAP Statistics (Details)

MultiProvider: 0TCT_MC02

MultiProvider 0TCT_MC02 is created on two InfoProviders:

0TCT_C02
0TCT_VC02

The Purpose of having a InfoCube and a VirtualProvider is to give historical as well as real-time or recent detail data of front end and query runtime statistics.

The query 0TCT_MC02_Q0200 is built on this MultiProvider.

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 Object Type	`0TCTBWOTYPE`
InfoObject	Handle ID, OLAP Statistics	`0TCTHANDLID`
InfoObject	Handle Type, OLAP Statistics	`0TCTHANDLTP`
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	Frontend session	`0TCTSESUID`
InfoObject	OLAP Statistics: Counter Indicator	`0TCTSTATCNT`
InfoObject	Statistics Event, OLAP Statistics	`0TCTSTATEVT`
InfoObject	Detail Level, OLAP Statistics	`0TCTSTATLEV`
InfoObject	Query Runtime Object, e.g Query/ Web Template/Workbook ...	`0TCTSTATOBJ`
InfoObject	OLAP Statistics: Time Key Figure	`0TCTSTATTIM`
InfoObject	Step Counter During Query Execution	`0TCTSTEPCNT`
InfoObject	Step Type, OLAP Statistics	`0TCTSTEPTP`
InfoObject	Query (Navigation) Step	`0TCTSTEPUID`
InfoObject	BW System	`0TCTSYSID`
InfoObject	UTC Time Stamp	`0TCTTIMSTMP`
InfoObject	Time registered in statistics for Step	`0TCTTMESTEP`
InfoObject	User	`0TCTUSERNM`
InfoObject	Time, Query Start (OLAP Statistics)	`0TCTUTIME`
InfoCube	Front-End and OLAP Statistics (Details)	`0TCT_C02`
InfoCube	Front-End and OLAP Statistics (Details)	`0TCT_VC02`
InfoObject	Weekday	`0WEEKDAY1`