Hi Gurus,
I have a weird situation: There is an BW 3.5 SP 16 (I know itu2019s oldu2026) infocube that receive 400,000 records every single day.
They never compressed (at least there is no data on E table), instead they ran a program calling FM u201CRSDRD_SEL_DELETION'u201D every day that takes about 5 hours to run (when it runs without errors).
So I checked Fact table and found 337,564,988 records. If you check the number of records on Infocube Admin it shows 14,018,370 record. I found that the u201Cmissingu201D record are not on P table (there is data on Fact pointing to missing Packages).
I think the Selective deletion messed up the infocube. These record that are missing on P table have to be deleted. I ran an RSRV check on this Infocube on Background and it canceledu2026
So, I want to delete this data from Fact my question is: How to do that with minimum effort without invalidade the information?
Of course I will backup the data to a temp cubeu2026
Well any idea is welcome 😊
Regards,
Alex