OLAP Usage for Each InfoCube (Time) 

Technical name: 0BWTC_C10_Q500

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

The query OLAP Usage per InfoCube (Time) (0BWTC_C10_Q500) offers an overview of the usage of Business Information Warehouse (OLAP), itemized according to InfoCubes.

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

·        What was the total time taken (OLAP) for each of the InfoCubes 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?

The queries Chart: OLAP Times per InfoCube (0BWTC_C10_Q050) and OLAP Usage per InfoCube (Time) (0BWTC_C10_Q500) are very similar. You can find additional information under Chart: OLAP Times per InfoCube (0BWTC_C10_Q050).

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
0TCTSYSID	BW System
0CALDAY	Calendar Day

Variables Used

Variable	Description
0TCTQUYS	Query
0TCTUSES	User

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_S100	Times (OLAP)

Example