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?