Delete Data from InfoCube Mode 
Delete Data from InfoCube Mode
Technical name: 0TCTDELMODE
Use
The characteristic Delete Data from InfoCube Mode (0TCTDELMODE) specifies the way in which the system carries out deletion.
Technical Data
|
Available as of Release |
2.1C/01 |
|
Reference Characteristics |
No |
|
External Hierarchy |
No |
|
Compounding |
No |
The characteristic can have the following characteristic values C,N,D and T:
C (Choose): The system automatically chooses the best delete mode. This is N or D.
N (Create New): If over 10% of an InfoCube’s data records are to be deleted, the system replaces the InfoCube fact table with a table with data records that are not to be deleted.
If you want to delete more than 10% of the records, the system creates a new table, copies the data records you want to keep to the new table, deletes the old table and then renames the new table.
D (Delete): If you want to delete less than 10% of the data records, the system deletes these individual records directly from the InfoCube fact table.
T (Truncate): If you want to delete all data records, the system deletes all data records from the tables, but retains the tables in the database.