OLAP Usage per Query 

Technical name: 0BWTC_C10_Q012

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

The query OLAP Usage per Query (Time) (0BWTC_C10_Q012) offers a detailed overview of the usage of Business Information Warehouse (OLAP), itemized according to BEx queries. The query contains all OLAP times and OLAP records in the columns (see structure Times and Data Records (OLAP)).

The graphic representation allows a quick overview with regard, for example, to the following question:

·        How do the total times (OLAP) and the number of transferred data records for each of the BEx queries examined relate to one another? (The chart has two y axes: On the left-hand side, the y axis shows the value scale for the time in seconds; on the right-hand side, the value scale is for the number of data records.)

You can expect that high amounts of data were transferred if high amounts of total time are displayed.

If a large amount of data was transferred in a comparatively short amount of time, or if large amounts of time appear even though only small amounts of data were transferred, then the results need to be analyzed further. In these cases, the examination of the time composition can help clarify the situation or indicate problems.

·        How much time did the individual processing steps take?

You can find additional information about the interpretation of time entries under OLAP Usage per Query (Time) (0BWTC_C10_Q502).

Filters

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTUSERNM	User restricted to characteristic variable user 0TCTUSES
0TCTIFCUBE	InfoCube restricted to characteristic variable InfoCube 0TCTCUBS
0TCTOLAPACT	OLAP Processor Method restricted to the following fixed values: = ODBO (5) = Print in Batch (2) = Execute Query/ Navigation Step (1)
0CALDAY	Calendar Day restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS
0TCTOBJVERS	Object Version restricted to fixed value = A

Free Characteristics

InfoObject	Description
0TCTSYSID	BW System

Variables Used

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

Rows

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTQUERY	Query restricted to characteristic variable query 0TCTQUYS

Columns

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0BWTC_C10_S010	Times and Data Records (OLAP)

Example