Start of Content Area

Query OLAP Usage for Each User (Overall Time)  Locate the document in its SAP Library structure

Technical name: 0BWTC_C10_Q505

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

This query shows the key figure Total Time (OLAP) for the characteristic User.

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

User

restricted to characteristic value variable user 0TCTUSES

Columns

InfoObject

Description of the InfoObject (Restriction or Calculation Formula)

0TCTTOLAPAL

Total Time (OLAP)

Example

This graphic is explained in the accompanying text

 

End of Content Area