OLAP Usage per User 

Technical name: 0BWTC_C10_Q011

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

This query allows the usage of Business Information Warehouse (OLAP) to be subdivided according to user. It contains the user characteristic (0TCTUSERNM) in the rows.

Since hierarchies are permitted for this characteristic, you can also set the respective queries in which a user hierarchy (some departments) is considered.

For each user, the key figures contained in the Times and Data Records (OLAP) (0BWTC_C10_S010) structure are shown in the columns: Number of Navigations (0TCTNAVCTR), Average Runtime (OLAP), Total Time OLAP (0TCTTOLAPAL), as well as all key figures regarding OLAP times and records.

Filters

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTOLAPACT	OLAP Processor Method restricted to the following fixed values: = ODBO (5) = Print in Batch (2) = Execute Query/ Navigation Step (1)
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
0TCTSYSID	BW System

Variables Used

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

Rows

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTUSERNM	User restricted to characteristic variable user 0TCTUSES

Columns

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0BWTC_C10_S010	Times and Data Records (OLAP)