OLAP Usage per Query (Time) 

Technical name: 0BWTC_C10_Q502

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

The query OLAP Usage per Query (Time) (0BWTC_C10_Q502) offers an overview of the usage of Business Information Warehouse (OLAP), itemized according to BEx queries.

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

·        How high was the total time taken (OLAP) for each of the BEx queries examined? The time is specified in seconds in the chart on the y axis.

·        How much time did the individual processing steps take?

·        Which special features stand out? What do these reveal? Are there improvement recommendations, where necessary?

You can find additional information about the interpretation of time entries under Chart: OLAP Times per InfoCube (0BWTC_C10_Q050).

Filters

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

Free Characteristics

InfoObject	Description
0CALDAY	Calendar Day
0TCTIFCUBE	InfoCube restricted to characteristic variable InfoCube 0TCTCUBS
0TCTSYSID	BW System

Variables Used

Variable	Description
0TCTUSES	User
0TCTCUBS	InfoCube

Rows

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTQUERY	Query 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_S100	Times (OLAP)

Example