Entering content frame

Query Deleting Data in InfoCubes - Overview Locate the document in its SAP Library structure

Technical name: BW_GEN_TCT_STA_Q_0BWTC_C10_Q252

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

F each InfoCube examined, this query shows in the columns the number of all data records and the time for the entire deletion process.

Filters

InfoObject

InfoObject description (and restrictions or calculation formulas)

0TCTDELMODE

Structure linkDeletion Mode

0TCTUSERNM

Structure linkUser

restricts to characteristic variable user 0TCTUSES

0CALDAY

Structure linkCalender Day

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

0TCTOBJVERS

Structure linkObject Version

restricts to fixed value = A

Free characteristics

InfoObject

Description

0TCTSYSID

Structure linkBW 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

Structure linkInfoCube

restricts to characteristic variable InfoCube 0TCTCUBS

Columns

InfoObject

InfoObject description (and restrictions or calculation formulas)

0TCTDELNALL

Structure linkNumber, All Data Records

0TCTDELTALL

Structure linkTime, Total Deletion Process

 

 

Leaving content frame