OLAP Performance with/without Read on Demand / Aggregates (SAP Library

OLAP Performance with/without Read on Demand / Aggregates

Technical name: 0BWTC_C10_Q022

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

This query contains the characteristics InfoCube (0TCTIFCUBE), Query (0TCTQUERY), OLAP Reading on/off (0TCTOLAPRD), and Aggregate (0TCTAGGREG) in the rows. In the columns, the key figures contained in the Average Times and Records (Navigation) (0BWTC_C10_S002) structure are shown: Number of Navigations (0TCTNAVCTR), Total Time OLAP (0TCTTOLAPAL), the consequentially calculated Average Total Time (OLAP), as well as all the average OLAP times and records.

This query enables a detailed valuation of aggregates with regard to their use and their requirements.

Filters

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0CALDAY	Calendar Day restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS
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

0TCTSYSID

Structure link BW System

0TCTUSES

Structure link User

restricted to characteristic value variable user 0TCTUSES

Variables Used

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

Rows

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTIFCUBE	InfoCube restricted to characteristic variable InfoCube 0TCTCUBS
0TCTQUERY	Query restricted to characteristic value variable query 0TCTQUYS
0TCTOLAPRD	OLAP Reading On / Off
0TCTAGGREG	Aggregate

Columns

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0BWTC_C10_S002	Average Times and Records (Navigation)