Deletion of data in OH table

[former_member214729]

Hi,

We have an open hub table which is having past 6 years data (around 600GB).

Due to the size constraint, we have got a requirement to retain only the records newer than 365 days in the OH table and to delete the other records.

We have DATE0 field to capture the date on when the record is inserted into the OH table.

We can write an ABAP program to delete the records from the table by checking the date value in DATE0 field.

Is there any other way to perform this activity in OH table like performing selective deletion in a DSO/Infocube?

Thanks

Dinesh R

[Former Member]

Hi Dinesh,

A simplest solution would be to export the last 365 days data from your OHD to a flat file (like archiving).

Then delete the entire contents of the OH table.

Once the OHD is cleaned up, we can reload the archived 365 days data back to the OHD.

So, only the last year data resides in the OHD.

Now, you can change the DTP settings that loads data to the OHD to filter out any historical data and load only the year's data henceforth.

Br,

H