Using InfoCubes: OLAP / WHM - Time (SAP Library - BW Statistics MultiProvider Queries)

Using InfoCubes: OLAP/WHM - Time

Technical name: 0BWTC_C10_Q401

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

This query enables the valuation of InfoCubes with regard to their use and their requirements. The graphic display enables a quick overview.

For each InfoCube, the key figures Total Time (OLAP) (0TCTNOLAPAL) and Total Loading Time (WHM) (0BWTC_C10_R200) are shown. The total time for the queries executed for an InfoCube needs to be clearly greater than the time required to load data.

The Using InfoCubes: OLAP/WHM (0BWTC_C10_Q400) BW statistics query enables a detailed valuation of InfoCubes with regard to their use and requirements.

Filters

InfoObject

InfoObject description (and restrictions or calculation formulas)

0TCTOBJVERS

Object Version

restricts to fixed value = A

0CALDAY

Calendar Day

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

Free characteristics

InfoObject	Description
0TCTSYSID	BW 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

InfoCube

restricts to characteristic variable InfoCube 0TCTCUBS

Columns

InfoObject	InfoObject description (and restrictions or calculation formulas)
0TCTTOLAPAL	Total Time (OLAP)
0BWTC_C10_R200	Total Load Time (WHM)

Example

This graphic is explained in the accompanying text