Entering content frame

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

Structure linkQuery

restricted to characteristic value variable query 0TCTQUYS

0TCTOLAPACT

Structure linkOLAP Processor Method

restricted to the following fixed values:

= ODBO (5)

= Execute Query/ Navigation Step (1)

0CALDAY

Structure linkCalendar Day

restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS

0TCTOBJVERS

Structure linkObject Version

restricted to fixed value = A

0TCTIFCUBE

Structure linkInfoCube

restricted to characteristic variable InfoCube 0TCTCUBS

Free Characteristics

InfoObject

Description

0TCTSYSID

Structure linkBW 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 linkUser

restricted to characteristic value variable user 0TCTUSES

Columns

InfoObject

Description of the InfoObject (Restriction or Calculation Formula)

0TCTTOLAPAL

Structure linkTotal Time (OLAP)

Example

This graphic is explained in the accompanying text

 

Leaving content frame