Selective deletion - two questions

[Former Member]

Hi All

I am asking for the information

First:

Where is stored information about selective deletion. Which tables in?

Who ,when, parameters, the number of removed records.

Second:

Some contraindications against removing records from ODS using native SQL?

Best regards

[Former Member · Accepted solution]

Hi Pawel,

You can check in table RSDRDLOGHEADER.

Regards

Sriram

[Former Member · Accepted solution]

Thank you Sriram

your reply helped me find tables which the information interesting me are found in

[Former Member · Accepted solution]

Sriram,

There is another table similar to RSDRDLOGHEADER called RSDDSTATDELE. Besides the fact that RSDDSTATDELE showing more info, when is RSDRDLOGHEADER more preferable to look at?

[Former Member]

Hi Pawel,

Selective deletion for the InfoCube and ODS will be similar process.In ODS, you will get an extra POP-UP Message Box.

STEPS:

1. First goto to Infocube/ODS Manage screen.In that, tab to content.Click on Selective Deletion.Now you will find an Pop-up screen,in that click on Delete Selection.

2. Enter the entries that you wanna delete and click on Execute.

3.Deletion job can be schedule in background.To do that, click on Selection and choose immediate option after that click on start.Now new job will be created for deletion process.

4.After Deletion, click on Continue.

All these deletion process will affect F & E table of the cube. If you need more detail with documents give me your email id....

Hope the above steps will help you out.

Regards,

Harini.

[sachin_kulshrestha2]

Hi,

Use context menu to select manage tab. Select content table.

Click on selective deletion -> log to get the details.

hope it helps