Deleting Data in InfoCubes 
Deleting Data in InfoCubes
Technical name: 0BWTC_C10_Q251
Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)
Use
This query shows the following key figures for each InfoCube examined in the columns:
A query that only shows the times for individual processing steps for deletion is
A query that only shows the key figures with regard to the number of data records is
Deleting Data in InfoCubes - Details, Records.A query that only shows the key figures with regard to the number of all data records and the time for the entire deletion process is
Deleting Data in InfoCubes - Overview.Filters
|
InfoObject |
InfoObject description (and restrictions or calculation formulas) |
|
0TCTDELMODE |
 Deletion Mode |
|
0TCTUSERNM |
User
restricts to characteristic variable user 0TCTUSES |
|
0CALDAY |
Calender Day
restricted to characteristic variable Tech.Cont.: Time Period, for which the data is selected 0TCTDATS |
|
0TCTOBJVERS |
Object Version
restricts to fixed value = A |
Free characteristics
|
InfoObject |
Description |
|
0TCTSYSID |
BW System |
Variables used
|
Variable |
Description |
|
0TCTUSES |
User |
|
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) |
|
0TCTDELNALL |
Number, All Data Records |
|
0TCTDELNDEL |
Number, Deleted Data Records |
|
0TCTDELTALL |
Time, Total Deletion Process |
|
0TCTDELTDEL |
Time, Records Deletion |
|
0TCTDELTANA |
Time, Analysis |
|
0TCTDELTIDX |
Time, Creating Indexes |
|
0TCTDELTDIM |
Time, Analyzing Dimension Tables |
|
0TCTDELTDRP |
Time, Deleting Partitions |
|
0TCTDELTTMP |
Time, Construction of Temporary Tables |
|
0TCTDELTREC |
Time, Counting Records |