Fact table size of the cube

[Former Member]

BW Gods!

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

Ashwin

[Former Member · Accepted solution]

Ashwin

Transaction Code

DB02>click on detailed analysis>in the windoe give your fact table name ex: /BIC/F(cUBE NAME) AND next screen you will see the details.

Hope this helps

Thanks

Sat

[Former Member · Accepted solution]

Thanks Sat,

I could see the size of my fact table. But when BW replicates the cube, when a selection criterion is set for deleting records, where does it replicate it to. My question I guess is where should I verify that there is enough DB Space for BW to do this operation.

Thanks Again

Ashwin

[Former Member · Accepted solution]

Ashwin

With my experience to find exact DB Space for BW you need to ask your BASIS/DBA consultant because they will have good idea about size of your server.

Thnaks

Sat

[Former Member · Accepted solution]

Thanks Sat.

[Former Member · Accepted solution]

You want to make sure you include space for the F fact table and the E fact table, assuming you compress the infocube. If you use DB02 and use wild cards you migh be able to get all teh size info in one shot.

Gnerally, he indices for an InfoCube don't occupy a lot of space, but they do take space.

The default InfoCube table space is PSAFACTD and indics are in PSAPFACTI - not 100% sure that is universal acorss all the different DBs. Your shop could also have put them in differnt tablespaces altogether. Probably worth a quick check with your DBAs - they might know that they have lot of space availalbe, and you don't need to take the time to run down the space usage info.

The table copy process will NOT delete the original fact tables unless/until it has successfully loaded to new copy.

[Former Member]

Ashwin

Check this link and it may help you.

Thnaks

Sat