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. RSDDSTATLOGGING, RSBERRORLOG).

Some of BW Statistics tables are listed below.

RSDDSTATLOGGING    –           Logging Table for OLAP Statistics (new)

RSBERRORLOG           –           (Logs for Incorrect Records) – stores error handling logs.

RSDDSTATAGGR          –           Statistics data BW for aggregate selection and accounting

RSDDSTATAGGRDEF   –           Statistics data OLAP: Navigation step / aggregate definition

RSDDSTATCOND          –           BW Statistics: Data on Condensing Run InfoCube

RSDDSTATDELE           –           BW Statistics: Data on Deletion of Data in InfoCube

RSDDSTATDM              –           Data Manager Query Statistic Records

RSDDSTATDTP –           Table for WHM Statistics. Details DTP

RSDDSTATINFO            –           BW Statistics (OLAP), Information by Navigation step

RSDDSTATEVDATA      –           BW Statistics (OLAP), Key Figures for the Events

RSDDSTATHEADER                 BW Statistics (OLAP), Information by Runtime Objec

I am going to discuss about one of such table (RSDDSTATLOGGING) and it’s periodic maintenance.

RSDDSTATLOGGING – Logging Table for OLAP Statistics (new)

RSDDSTATLOGGING is one of the BW statistics data tables which potentially grow very fast, causing problems for users to login/access reports.

If we have short dump issues related to inserts on RSDDSTATLOGGING, then, we have to delete the contents of this table (Of course, business approvals are necessary in established environments)

The option to clear the contents is given below in section 1

For regular maintenance, please check Section 2.

1.    Use Program to delete Statistics data

 Step1 : Get electronic approval from Business(as the case maybe)

Step 2 : Delete contents Using program RSDDSTAT_DATA_DELETE

Step 2.1) Go to se38 and enter program name RSDDSTAT_DATA_DELETE and then click on execute and it will take to next screen

–

In the 2nd screen (see below)

Step 2.2) Select (þ) “Statistics Logging Tables under which data is to be deleted?”, tab (see screen shot below)

Step 2.3) Select date/duration under “Date up until which data is to be deleted?” tab. (In the screen shot given above, All option was selected to delete all contents. However, if you want to delete contents by date, go to transaction RSDDSTAT first, and find the appropriate Dates for which you want to run this program to delete contents from the RSDDSTATLOGGING table.)

Step 2.4) Ask DB team to run re-org on the RSDDSTATLOGGING table

2.    Regular Maintenance:

SAP has delivered the note 1476860 in the similar context.

It will allow us to delete data from this table by Date but also internally by X number of records, doing a commit at the end of each packet. If this note is not delivered as part of your SAP, it need to be applied and the parameter BW_STATLOG_DELPKGSIZE needs to be set to 50000 records in RSADMIN table.

Prerequisite(s):

You have to ensure that your regular statistics chains have executed successfully.

You have to ensure that this activity is performed during a quiet time (ideally on weekends or late Fridays, skipping month end periods)

step 1)       Do an initial reduction of the table using the “Older than 30 Days” option as selection.