Using InfoCubes (SAP Library - BW Statistics MultiProvider Queries)

Using InfoCubes

Technical name: 0BWTC_C10_Q020

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

The query Using InfoCubes (0BWTC_C10_Q020) shows, for each InfoCube, the key figures contained in the Last Use (Navigations) (0BWTC_C10_S011) structure: the Number of Navigations (0TCTNAVCTR), as well as the date (0BWTC_C10_CK010) and the time of the last use (0BWTC_C10_CK011). Therefore, this query enables a quick overview of frequently used or no longer used InfoCubes.

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	BW System

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)

0TCTIFCUBE

Structure link InfoCube

restricted to characteristic variable InfoCube 0TCTCUBS

Columns

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

Example

This graphic is explained in the accompanying text