OLAP Usage (SAP Library - BW Statistics MultiProvider Queries)

OLAP Usage

Technical name: 0BWTC_C10_Q010

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

This query enables the valuation of BEx queries with regard to their use (OLAP).

The key figures contained in the Times and Data Records (OLAP) (0BWTC_C10_S010) structure are shown in the columns. In contrast to the BW statistics query Runtime Query (0BWTC_C10_Q014), the BEx queries examined are sorted according to the characteristic InfoCube.

This BW statistics query can be used to reinforce the OLAP Usage per InfoCube (0BWTC_C10_Q013) query.

Filters

InfoObject

Description of the InfoObject (Restriction or Calculation Formula)

0TCTOLAPACT

Structure link OLAP Processor Method

restricted to the following fixed values:

= ODBO (5)

= Print in Batch (2)

= Execute Query/ Navigation Step (1)

0TCTOBJVERS

Structure link Object Version

restricted to fixed value = A

Free Characteristics

InfoObject	Description
0TCTSYSID	BW System
0TCTUSERNM	User restricted to characteristic value variable user 0TCTUSES
0TIME	Time
0CALDAY	Calendar Day restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS
0TCTRTIMEC	Runtime Category
0TCTOLAPRD	OLAP Reading On / Off
0TCTNAVSTP	Navigation Step
0TCTDBSELTP	Type of Data Read
0TCTAGGREG	Aggregate
0TCTTIMSTMP	UTC Time Stamp

Variables Used

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

Rows

InfoObject

Description of the InfoObject (Restriction or Calculation Formula)

0TCTIFCUBE

Structure link InfoCube

restricted to characteristic variable InfoCube 0TCTCUBS

0TCTQUERY

Structure link Query

restricted to characteristic value variable query 0TCTQUYS

Columns

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