Space Management in BW

Finding how much dB % A cube is occupying1) Go to SE11 type PSA table name/BIC/B ********** and display the table.

Now u have tab technical setting at top click it
And it will display the table space and the size

For cube/bib/d ********

2) If you are maintaining the statistics. You can check the reports of Statistics multiprovider. Or you can also check with statisctis cube.

3) to see the disk space used from an infocube you shoshould see tcode DB02 and shoshould sum all the involved tables (detailed analysis-> Object Name "<ic_name>"), so e, F and dim tables.

4) You can use rsrv-> All Elementary tests-> database information about infoprovider tables to get the rows in the fact tables and dimension tables.

You can also use the program sap_infocube_designs.

5) goto T. code, DB02 and there u can see the over all database details. look down in the "tables, indexes, stored Procedures "There select space statistics then it will popup a selection there select Top N largest tables and check the PSA table with the table name like/BIC/b00000000000.

If u have several requests in the PSA then u can delete them having a few requests in the PSA.

6) in DB02 transaction code see at the bottom U cocould see these,

1. Detailed Analysis
2. Missing Indexes
3. Space statistics
4. Checks

In this select the 3rd one, u shocould get the popup.

Check this link:
Https://www.sdn.sap.com/irj/sdn/thread? Forumid = 131 & threadid = 142810 & messageid = 1596957

You can always delete old PSA data that is no more required which will enable the DBA to re-org PSA even from other PSA tables where space is surplus.