Entering content frame

InfoCube documentation BW Statistics – OLAP Locate the document in its SAP Library structure

Technical name: 0BWTC_C02

Use

The BW Statistics – OLAP InfoCube contains the data that is generated as a result of executing the queries. The reporting authorizes for this InfoCube, for example, how often certain InfoCubes or queries are used. In addition, detailed information is available for runtimes and data volume, for example.

InfoSources

InfoSources are automatically installed when transferring the technical content. The name of the particular InfoSource corresponds to that of the selected InfoCube.

Characteristics

InfoObject

Description

0TCTIFCUBE

InfoCube

0TCTNAVSTP

Navigation Step (current numbers within the session)

0TCTOLAPRD

OLAP Reading On / Off

0TCTRTIMEC

Runtime Category (1, 2, 3, ... 10, 20, 30, ... Seconds)

0TCTSYSID

BW System

0TCTUSERNM

User

0TCTOLAPACT

OLAP Processor Method

0TCTNAVUID

Navigation Step (GUID)

0TCTSESUID

Frontend Session (GUID)

0TCTSTAUID

Statistical Data (GUID)

0TCTOBJVERS

Object Version (for example, 0TCTIFCUBE)

0TCTDBSELTP

Type of Data Read

0TCTTIMSTMP

UTC Time Stamp

0TIME

Time

0TCTQUERY

Query

For the characteristics OLAP Processor Method (0TCTOLAPACT) and Type of Data Read (0TCTDBSELTP), both of the different fixed values are possible. You can find additional information under OLAP Processor Method and Type of Data Read.

Time Characteristics

InfoObject

Description

0CALDAY

Calendar Day

As of BW Release 3.0, the following time characteristics are available:

0CALYEAR

Calendar Year

0CALMONTH

Calendar Year / Month

0CALQUARTER

Calendar Year / Quarter

0CALWEEK

Calendar Year / Week

Key Figures

InfoObject

Description

0TCTSDATE

Start Date

0TCTSTAUIK

Frequency

0TCTSTIMEK

Start Time

0TCTDBSCTR

Number of Database Selects

0TCTNAVCTR

Number of Navigations

0TCTSESCTR

Number of Frontend Sessions

0TCTCHAVRD

Number of Texts Read

0TCTNCELLS

Cells Transferred to the Frontend

0TCTNDBSEL

Records Selected on the Database

0TCTNDBTRA

Records transferred from the Database to the Server

0TCTNODBOBS

ODBO: Size of the Internal Buffer

0TCTNODBOCA

ODBO: External Calls for the Function Module

0TCTNOLAPAL

Total (OLAP)

0TCTNOLARD

Read Cycles (Fetch) OLAP Processor

0TCTNRANGS

Formattin Transferred to the Frontend

0TCTNTEXTS

Number of Texts Read

0TCTTAUTH

Time, Authorization Check

0TCTTDBRD

Time, Reading on the Database

0TCTTDMCACC

Time, Data Manager InfoCube Access

0TCTTDMDBB

Time, Data Manager Reading from BasicCube

0TCTTDMDBO

Time, Data Manager Reading from ODS

0TCTTDMDBR

Time, Data Manager Reading from RemoteCube

0TCTTDMNCUM

Time, Data Manager Authorizations for Non-Cumulatives

0TCTTDMRSID

Time, Data Manager Determining SIDs for RemoteCube

0TCTTFRONT

Time, Frontend

0TCTTNAVIG

Time Between Navigation Steps

0TCTTODBOAL

Time, General ODBO

0TCTTODBOAX

Time, ODBO: Axes Preparation

0TCTTODBODA

Time, ODBO: Data Records Preparation

0TCTTODBOFL

Time, ODBO: Conversion into Flat Table Form

0TCTTODBOIN

Time, ODBO: Initialization

0TCTTODBORE

Time, ODBO: Data Requests

0TCTTOLAPAL

Total Time (OLAP)

0TCTTOLINI

Time, OLAP Processor Initialization

0TCTTRDMDA

Time, Reading Texts/Master Data

0TCTTREST

Time That the System Was Unable to Assign

0TCTTVARDP

Time, Inputting Variables

0TCTTOLAP

Time, OLAP Processor

 

 

Leaving content frame