Skip to Content
0
Former Member
Jul 02, 2007 at 02:38 PM

Selectiv deletion on huge infocube. DELETE_FACTS RS_ADMIN.

127 Views

Hi,

I have an InfoCube with 400 million records. I would like to delete 75% of these. I am not keen on creating a new infocube and load the data to this. Partly because of complex delta and because of lack of place.

I only have the option of a selective deletion. I am going to delete using programs generated by the program DELETE_FACTS with variants in a process chain.

I read about BW_SELDEL_PERC_THRES to be set to 10% in RS_ADMIN, but with my lack of space that could be a problem to use as well.

My question is: How can this deletion be done most efficient? Which approach would you recommend?