Front-End and OLAP Statistics (Highly Aggregated)

MultiProvider: 0TCT_MCA1

MultiProvider 0TCT_MCA1 is created on two InfoProviders:

0TCT_CA1
0TCT_VCA1

The purpose of basic cubes and virtual cubes is to provide historical as well as real-time or recently aggregated data for front-end and OLAP statistics.

The following queries are built on this MultiProvider:

0TCT_MCA1_Q0111
0TCT_MCA1_Q0112
0TCT_MCA1_Q0113
0TCT_MCA1_Q0114
0TCT_MCA1_Q0121
0TCT_MCA1_Q0122
0TCT_MCA1_Q0123
0TCT_MCA1_Q0124
0TCT_MCA1_Q0131
0TCT_MCA1_Q0132
0TCT_MCA1_Q0133
0TCT_MCA1_Q0134

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	InfoProviders Used	`0TCTIFPROV`
InfoObject	InfoProvider Type	`0TCTIFTYPE`
InfoObject	Initialization / Navigation Flag	`0TCTINITFLG`
InfoObject	Object Version	`0TCTOBJVERS`
InfoObject	Counter for BI Application Objects	`0TCTQUCOUNT`
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	Time recorded for OLAP	`0TCTTMEOLAP`
InfoObject	Time recorded for Planning	`0TCTTMEPLAN`
InfoObject	User	`0TCTUSERNM`
InfoObject	Counter for BI Applications	`0TCTWTCOUNT`
InfoCube	Front-End and OLAP Statistics (Highly Aggregated)	`0TCT_CA1`
InfoCube	Front-End and OLAP Statistics (Highly Aggregated)	`0TCT_VCA1`
InfoObject	Weekday	`0WEEKDAY1`