Show TOC

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

MultiProvider MultiProvider: 0TCT_MC01

 

MultiProvider 0TCT_MC01 is created on two InfoProviders:

  • 0TCT_C01

  • 0TCT_VC01

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

Following queries are built on this MultiProvider

  • 0TCT_MC01_Q0111

  • 0TCT_MC01_Q0112

  • 0TCT_MC01_Q0113

  • 0TCT_MC01_Q0114

  • 0TCT_MC01_Q0121

  • 0TCT_MC01_Q0122

  • 0TCT_MC01_Q0123

  • 0TCT_MC01_Q0124

  • 0TCT_MC01_Q0131

  • 0TCT_MC01_Q0132

  • 0TCT_MC01_Q0133

  • 0TCT_MC01_Q0134

  • 0TCT_MC01_Q0200

  • 0TCT_MC01_Q0201

  • 0TCT_MC01_Q0202

  • 0TCT_MC01_Q0313

  • 0TCT_MC01_Q0314

  • 0TCT_MC01_Q0323

  • 0TCT_MC01_Q0324

  • 0TCT_MC01_Q0333

  • 0TCT_MC01_Q0334

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

InfoCube

Front-End and OLAP Statistics (Aggregated)

0TCT_C01

InfoCube

Front-End and OLAP Statistics (Aggregated)

0TCT_VC01

InfoObject

Weekday

0WEEKDAY1