1.SAP_DROP_TMPTABLES
2.RSB_ANALYZE_ERRORLOG anf then use RSBM_ERRORLOG_DELETE
1.Clean up PSA for every 15 days
2. Optimize the Aggregates ( Delete bad Aggregates, If u have )
3. Compress the Cubes to washout duplicate records.
4.If you have more historic data, currently not in reporting scope..ARCHIVE that data in different formats.
: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/342cba90-0201-0010-0d99-ab4bfb868eb6
SAP NetWeaver - Data Warehousing with Large Data Volumes
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d56bbf90-0201-0010-53aa-923512127968
5.By Using transaction ST14 you can find the detail information of space used by objects (infocube/ods/psa).you need to schedule the job in ST14 to get the first result for top 30 objects.
ST14 lets you run a job that collects info on the Top 30 largest InfoCubes - considers E and F fact tables separately ( 30 largest Es, and 30 largest Fs).
It will provide:
Top 30 PSA Elements
Top 30 ODS Elements
Top 30 E-Fact tables
Top 30 F-Fact tables
Top 30 Dimension Tables
Top 30 Aggregates
Top 30 Master Data Tables
Top 30 Object tables
Top 30 Other Tables
Top 30 Change Logs
Top 30 Cubes
6. Check the size of object through DB02...object name and then add the size of all the tables pertaining to that object.
--------------------------------------------------------------------------
RSBERRORLOG Table performance problem
RSBM_ERRORLOG_DELETE
If you are running on oracle please run a online reorg on rsberrorlog.
1144400-RSBM_ERRORLOG_DELETE no frequent commits.
1095924-Correction: Deletion/analyis report for error handlign logs.
If you are on SAP_BW 701 above notes are not applicable ... you can go ahead and run report (RSBM_ERRORLOG_DELETE).