Cleaning up statistic tables in BI

In order to keep your BI system healthy, it's necessary to clean-up some statistical tables once in a while. Especially in BI 7.0 I experienced some tables growing rapidly (e.g. DTP statistics).

In RSA1 goto Tools à Settings for BI Statistics.

Choose and select the tables you want to clean up:

Which option cleans which tables? Here you go:

Option	Tables
Query Statistics Tables	RSDDSTATHEADER, RSDDSTATDM, RSDDSTATEVDATA, RSDDSTATAGGRDEF, RSDDSTATINFO.
Statistic Loggin Tables	RSDDSTATLOGGING
Aggregates/BIA Index Process	RSDDSTATAGGR, RSDDSTATTREXSERV, RSDDSTATTREX,
InfoCube Statistics (Delete, Compress)	RSDDSTATDELE, RSDDSTATCOND

Didn't see this option in 3x System. There you can execute the same program manually: RSDDSTAT_DATA_DELETE.

Is your 'huge' table not here, maybe this will help:

Datasources	Tables
0TCT_DS01, 0TCT_DS02, 0TCT_DS03	RSDDSTATHEADER, RSDDSTATINFO RSDDSTATEVDATA RSDDSTATDM

By loading Technical content, data in these tables is automatically saved for 14 days. To change the # of days: change parameter TCT_KEEP_OLAP_DM_DATA_N_DAYS in table RSADMIN.

Last but not least: Table BALDAT (Application Log) can be cleaned with tcode SLG2.

Good luck!