OLAP Usage for Each User (Time) (SAP Library - BW Statistics MultiProvider Queries)

OLAP Usage for Each User (Time)

Technical name: 0BWTC_C10_Q503

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

For each user, this query displays the key figures contained in the Times (OLAP) (0BWTC_C10_S100) structure. The total of these times produces the Total Time (0TCTTOLAPAL). In this way, this query reinforces the BW statistics query OLAP Usage per User (Total Time) (0BWTC_C10_Q505).

See also:

OLAP Usage per User (0BWTC_C10_Q011).

Filters

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTQUERY	Query restricted to characteristic value variable query 0TCTQUYS
0TCTOLAPACT	OLAP Processor Method restricted to the following fixed values: = ODBO (5) = 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
0TCTIFCUBE	InfoCube restricted to characteristic variable InfoCube 0TCTCUBS

Free Characteristics

InfoObject	Description
0TCTSYSID	BW System

Variables Used

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

Rows

InfoObject

Description of the InfoObject (Restriction or Calculation Formula)

0TCTUSERNM

Structure link User

restricted to characteristic value variable user 0TCTUSES

Columns

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0BWTC_C10_S100	Times (OLAP)

Example

This graphic is explained in the accompanying text