Entering content frame

Query Using InfoCubes: Reporting/Loading Locate the document in its SAP Library structure

Technical name: 0BWTC_C10_Q508

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

This query is available for BW Release 2.x. The query definition includes the Using InfoCubes: OLAP/WHM (0BWTC_C10_Q400) BW statistics query.

Filters

InfoObject

InfoObject description (and restrictions or calculation formulas)

0TCTOBJVERS

Structure linkObject Version

restricts to fixed value = A

0CALDAY

Structure linkCalendar Day

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

Free characteristics

InfoObject

Description

0TCTSYSID

Structure linkBW System

Variables used

Variable

Description

0TCTDATS

Tech.Cont.: Time Period, for which Data is Selected

0TCTCUBS

InfoCube

Rows

InfoObject

InfoObject description (and restrictions or calculation formulas)

0TCTIFCUBE

Structure linkInfoCube

restricts to characteristic variable InfoCube 0TCTCUBS

Columns

InfoObject

InfoObject description (and restrictions or calculation formulas)

 

Time (OLAP/WHM)

calculates from the key figures Structure linkTotal Time (OLAP) (0TCTTOLAPAL) and Structure linkTotal Load Time (0TCTNAVCTR) according to the formula 'Total Time (OLAP)' / 'Number of Navigations'

 

Records (OLAP/WHM)

calculates from the key figures Structure linkTotal (OLAP) (0TCTTOLAPAL) and Structure linkTotal Number of Records (0TCTNAVCTR) according to the formula 'Total Number (OLAP)' / 'Total Number of Records'

 

 

Leaving content frame