Friday, July 17, 2009

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!

1 comment: