Using InfoCubes: OLAP/WHM - Records 
Using InfoCubes: OLAP/WHM - Records
Technical name: 0BWTC_C10_Q402
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 Number (OLAP) (0TCTNOLAPAL) and Total Number of Records (WHM) (0BWTC_C10_R201) are shown. Altogether, more data records need to have been read when executing queries than were loaded into the InfoCube, meaning each data record loaded needs to have been read multiple times
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) |
|
0TCTNOLAPAL |
Total (OLAP) |
|
0BWTC_C10_R201 |
Total Number of Records (WHM)
|
Example
