Show TOC

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

InfoCube InfoCube: 0TCT_CA1

 

InfoCube 0TCT_CA1 is a basic cube that contains highly aggregated front-end and OLAP statistics.

This InfoCube is used for monitors that display all the aggregated values of the front end and OLAP for BI applications, BI application objects, and InfoProviders on the portal. These statistics do not include the UTC time stamp details.

Example Example

A query is executed three times a day, and you get three sets of BI applications, BI application objects, and unassigned records for each execution. After the data is loaded into the cube, the hour slot and UTC time stamp details are lost. You have aggregated the results of the three executions.

End of the example.

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

InfoObject

Weekday

0WEEKDAY1