Skip to Content
0
Former Member
Jan 18, 2012 at 11:07 AM

BW 3.5 Fact table with data no corresponding records on P table

34 Views

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