Rolling up Aggregates 

Technical name: 0BWTC_C10_Q211

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

Aggregates make it possible to access InfoCube data quickly in reporting. In doing so, aggregates help improve performance. (See Aggregate.)

In order to be able to insert aggregates effectively, it is important to find out which aggregates are frequently used or have not been used in a long time. This BW statistics query contains the key figures Number of Navigations (0TCTNAVCTR), Last Use (Day) (0BWTC_C10_CK010), as well as Last Use (Time) (0BWTC_C10_CK011) for the characteristic Aggregate (0TCTAGGREG) during the execution of a query. (See the Last Use (Navigations) structure.)

You can find additional information about the suggested aggregates from the BW statistics and optimizing suggested aggregates under Automatic Selection and Optimization of Aggregates.

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
0TCTOBJVERS	Object Version restricted to fixed value = A

Free Characteristics

InfoObject	Description
0TCTIFCUBE	InfoCube restricted to characteristic variable InfoCube 0TCTCUBS
0TCTUSERNM	User
0TCTPARCUBE	Higher-level Cube (InfoCube from which Aggregate Was Supplied with Data)
0TCTSYSID	BW System
0TCTAGRCUBE	Aggregate Cube

Variables Used

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

Rows

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTAGGREG	Aggregate

Columns

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0BWTC_C10_S011	Last Use (Navigations)