OLAP Usage by InfoCube (Records) 

Technical name: 0BWTC_C10_Q501

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

The queryOLAP Usage by InfoCube (Records) (0BWTC_C10_Q501) offers an overview of the usage of the Business Information Warehouse (OLAP), itemized by InfoCubes.

This graphic representation enables a quick overview with regard, for example, to the following questions:

How many records were processed in total in the OLAP area for each of the InfoCubes examined?

The total number of data records (OLAP) results from the total of all data records for each InfoCube. The total height of the bars represents the total number of data records. The vertical axes on the left-hand side specify the number of records.

How many data records were processed in the individual process steps for each of the InfoCubes examined?

The following key figures in the Data Records (OLAP) (0BWTC_C10_S101) structure were evaluated for this and displayed as segments of the bars in different colors:

·         Records selected from the database (0TCTNDBSEL)

·         Records transferred from the database to the application server (0TCTNDBTRA)

·         Cells transferred to the frontend (0TCTNCELLS)

·         Formatting transferred to the frontend (0TCTNRANGS)

·         Number of texts read(0TCTCHAVRD)

You can find additional information about the number of data records under Chart: OLAP Records per InfoCube (0BWTC_C10_Q051).

Filters

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTQUERY	Query restricted to characteristic variable query 0TCTQUYS
0TCTUSERNM	User restricted to characteristic variable user 0TCTUSES
0TCTOLAPACT	OLAP Processor Method restricted to the following fixed values: = ODBO (5) = Execute Query/ Navigation Step (1)
0TCTOBJVERS	Object Version restricted to fixed value = A

Free Characteristics

InfoObject	Description
0CALDAY	Calendar Day restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS
0TCTSYSID	BW System

Variables Used

Variable	Description
0TCTQUYS	Query
0TCTUSES	User
0TCTDATS	Tech.Cont.: Time period, for which data is selected

Rows

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTIFCUBE	InfoCube restricted to fixed value “exclude # from selection”, meaning that all the records that have not been posted or all the entries that have not been assigned are excluded

Columns

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0BWTC_C10_S051	Data Records (OLAP)

Example