I need to selectively delete data from a cube which holds data from 2001-2006.....say I want to delete data only for 2001. It was suggested to me by pizzaman in one of our earlier threads that BW would decide if the data to be deleted is more than 10% of the cube size and if it is, it would just copy the cube without the data which has to deleted and it would rename the cube. So he suggested that I should find out the fact table size and make sure that there is enough space in my fact tablespace for this operation to go on.
My question is, how do I find out the fact table size of the cube?
How do I find out if there is enough space on fact tablespace for the above said deletion operation to be executed.
I am not too sure whether I have put across the question correctly. Let me know.
Thank you all in adavance