Entering content frame

Query Deleting Data in InfoCubes – Details, Records Locate the document in its SAP Library structure

Technical name: 0BWTC_C10_Q254

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

In the columns, this query shows for each InfoCube examined the key figures with regard to the number of all data records and the number of deleted data records.

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

0TCTDELNDEL

Structure linkNumber, Deleted Data Records

 

 

Leaving content frame