Task list

Authorization - Delete un-used BW accounts
Meta data - Delete un-used queries
Meta data - Delete un-used bex web bookmarks
Meta data - Delete un-used bex broadcaster bookmarks
Meta data - Delete un-used workbooks & roles content

Authorization

Before launching any of the following clean up actions, it is better if all the BW users accounts that have not been used for a long time (<6 months) be deleted from the system. This is because in some cases, data cannot be deleted if the user still exists.

Meta data

Delete un-used queries & workbooks

Transaction : RSZDELETE
Main Parameter : Last Use Date < current date - 365
See specific page for this process : Un-Used Query Deletion Process

Main Parameter	Value
Last Use Date	current date - 365

Delete un-used Bex Web bookmarks

1 - Go to transaction Se38

2 - Run program RSRD_ADMIN_BOOKMARKS_3X (For old 3.x version bookmarks)

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-10 14:18:52.png

3 - Select All users. For Created Before/Last Access, put Current Date - 365

4 - Select All bookmarks and delete

You need to repeat the select all + delete several times if necessary as the initial screen only shows a few bookmarks

RSRD_ADMIN_BOOKMARKS_3X can only delete 3.x version bookmarks. Program RSWR_BOOKMARK_REORG can be used to delete 7.x bookmarks but the problem is that you cannot know if it's still in use - So it's not included in this process.

Delete Bex Broadcaster Bookmarks

1 - Go to transaction SE38

2 - Run program RSRD_BOOKMARK_REORGANISATION

3 - Input "365" in Older Than Days

4 - Uncheck "Test Call (No Delete)" - Otherwise no real deletion will be done

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-10 14:37:44.png

Main parameter

Value

Temporary Bookmark ID

Older than (In days)

365

Bookmark IDs

Old than (In days)

365

Test Call (No delete)

Uncheck

Delete un-used workbooks & roles content

1 - Go to transaction SE38

2 - Run program RSWB_ROLES_REORG

3 - Choose "Only Examine BW Roles"

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-10 14:11:28.png

This report has several sections :

Section	Explanation	Action
Incorrect References from Workbooks in Roles	References from workbooks in roles that do not exist in workbook storage	Delete all
Workbooks without Query Assignment	References to workbooks in roles that do not have a query assignment	DO NOT DELETE
Incorrect References from Workbooks in Favorites	References from workbooks in favorites that do not exist in workbook storage	Delete all
References from workbooks in favorites that do not exist in workbook storage	References to workbooks in favorites that do not have a query assignment	DO NOT DELETE
Unused Workbooks	Workbooks in workbook storage that are not referenced in roles or favorites	Delete all

Main tables cleaned
RSRWBSTORE AGR_HIER AGR_HIERT RSRWORKBOOK SMEN_BUFFC RSRWBINDEX RSRWBINDEXT

Statistics

Delete Temporary Tables - Optional

This operation should only be done if temporary tables are taking a lot of space. Check in DB02 all tables starting with "/BI0/0"

1 - Go transaction Se38

2 - Run program SAP_DROP_TMPTABLES

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-10 14:50:49.png

Main tables cleaned
/BI0/0*

Deleting DTP Error Log

The DTP error log can be analysed via program RSB_ANALYZE_ERRORLOG.

To delete the DTP error log :

1 - Go to transaction SE38

2 - Run program RSBM_ERRORLOG_DELETE

3 - Input "30 days" in the "but always older than ... days" parameter

4 - Check "Delete log"

5 - Run - If large, run in Background

Main parameter	Value
but always older than ... days	30
delete log	Checked

Main tables cleaned
RSBERRORLOG (+ indexes)

Deletion of BW Statistics

1 - Go to transaction SE38

2 - Run program RSDDSTAT_DATA_DELETE

3 - Select all checkboxes for data to be deleted

4 - Free Date selection : Current Date - 365

5 - In the Date up until which data is to be deleted, select "Date Selection" and then enter Current date - 365 in the "Up to Day (Incl.)" field.

Main parameter	Value
Up to day (Inc)	Current Date - 365

Main tables cleaned

All RSDDSTAT* :

RSDDSTATLOGGING
RSDDSTATDTP
RSDDSTATAGGRDEF
RSDDSTATEVDATA
RSDDSTATHEADER
RSDDSTATAGGRDEF

(+Indexes)

Delete RSST logs

1 - Go to transaction SE38

2 - Run program RSTT_TRACE_DELETE

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-10 17:17:15.png

Main parameter	Value
Ignore Number of Last Days	100
Application Area	BW_BEX

Main tables cleaned
RSTT_CALLSTACK RSTT_TRACE

Delete Sent Documents - Hidden documents

1 - Go to transaction SE38

2 - Run program RSSODFRE

3 - Select Minimum Age (Days) = 60

4 - Check the 2 delete boxes

5 - Uncheck Test Mode

6 - Execute the program

Main parameter	Value
Minimum Age (Days)	30
Test Mode	Unchecked
Delete documents linked	Checked
Delete unsent documents	Checked

Main tables cleaned

SOFFCONT1

BCST_CAM

BCST_RE

BCST_SR

SOC3

SOCS

SOES

SOFM

SOOD

SOOS

SOST

Delete Sent Documents - Private Documents

1 - Go to transaction Se38

2 - Run program : RSSO_DELETE_PRIVATE

3 - Select all types of messages (Inbox to Private Trash)

4 - For Inbox, check “All” instead of “Viewed”

5 - Uncheck Test Mode

6 - Run the program

Main parameter	Value
Minimum Age (Days)	60
Inbox	All
Test Mode	Unchecked
Delete unsent documents	Checked

Reorg Documents & Sent requests

1 - Go to SE38

2 - Run program RSBCS_REORG

3 - Select "Specify Age (in Days)" and select from 60 to 9999.

4 - Uncheck the "Test Mode"

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 13:44:2.png

Main parameter	Value
Age in days	60 to 9999
Test Mode	Unchecked

Deletion of Log Files - PC Instances

1 - Go to SE38

2 - Run program RSPC_INSTANCE_CLEANUP

3 - In Older than : current date - 365

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 14:11:24.png

Main parameter	Value
Older Than	Current Date - 365
Delete Logs	Checked

Main tables cleaned
RSPCINSTANCE RSPCINSTANCET

Deletion of Log FILES - Process Chain Log

1 - Go to SE38

2 - Run program RSPC_LOG_DELETE

3 - In the "Up to and including date" enter current date - 365

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 14:19:10.png

Main parameter	Value
Up to and including date	Current Date - 365

Main tables cleaned
RSPCLOGCHAIN RSPCPROCESSLOG

Deletion of Log Files - Job Status

This is already scheduled automatically (at least on WBP)

1 - Go to SE38

2 - Run program RSBTCDEL2

3 - Run with default values and "Test Run" unchecked

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 14:29:59.png

Main tables cleaned
TBTCO

Deletion of Log Files - Application logs

1 - Go to transaction SE38

2 - Run program SBAL_DELETE

3 - Select Expiry Date "and logs which can be deleted before the expiry date"

4 - In from (date/time) to (date/time) select "01.01.1900" and current date - 730 days

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 14:48:14.png

Main parameter	Value
Expiry Date	and logs which can be deleted before the expiry date
from (date/time)	01.01.1900
to (date/time)	current date - 730 days

Main tables cleaned
BALHDR BALDAT

Delete Idocs

1 - Go to SE38

2 - Run program RSETESTD

The BW team doesn't have the access to run this report - It is necessary to request it from the SAP Technical Team

Main tables cleaned

EDI40

EDIDC

EDIDS

Deletion of Change Log

How to check the biggest table of Change Log

Go to Tcode DB02
Select Space --> Additional Function --> BW Analysis. The overall size of change log will be display like picture below.
Double click on ODS & Changelog line to display detail of each DSO. Sort the size in order to see the biggest table.
Then, go to check on the flow in process chain. In order to delete the changelog, it has to be deleted by process chain.

How to Delete Change Log

Add object 'Deletion of Requests from
Enter parameter for each DSO including in the process chain. The time should be 10 days or less. It can be 0 if the DSO is loaded by full

Note:

The best practice is modified process chain in development system
Deletion of changelog should be at the end of process chain.
Check the big table of changelog once a year and if missing process is found, modify the process chain by adding the deletion of PSA

Business Data

Delete empty, un-used partitions for cubes

For each of the largest partitioned cubes, this can be run to delete useless partitions. This is particularly important after data was deleted from the cubes.

1 - Go to SE38 transaction

2 - Run program SAP_DROP_EMPTY_FPARTITIONS

3 - Input in CUBENAME the name of the cube you want to clean

4 - Execute once with the "Show Option"

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 16:55:7.png

5 - Check the result of the analysis

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 17:4:28.png

6 - Depending on the result, re-execute the program with "DO_DROP" checked and either "DEL_CNT" or "DEL_DIM"

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-11 17:10:27.png

Deletion of Aggregates

1 - Go to RSA1 transaction

2 - In the left menu, click on Administration --> Monitors --> Aggregates

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-12 10:5:23.png

3 - Analyse each aggregate to see if it is useful

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-12 10:10:10.png

To know if the aggregate can be deleted :

If the cube is already in BI Acceletor --> Delete the aggregate as BI Accelerator is used first.
If the valuation of the aggregate is not positive (Ex : |+++ ) then it means it doesn't improve the execution time --> Delete the aggregate
If the number of "Usage" is very low considering the time since the aggregate creation --> Delete the aggregate since it's not used much

4 - To delete the aggregate, for each cube selected, go to RSA1

5 - Select the cube and right click --> Manage

6 - Go to the Rollup tab and click on "Aggregates"

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-12 10:18:17.png

7 - Select the aggregate, right click and delete

TECHNO - BI TEAM > House Cleaning Procedure / housekeeping > image2015-8-12 10:19:8.png

Deletion of PSA

How to check the biggest table of PSA

Go to Tcode DB02
Select Space --> Additional Function --> BW Analysis. The overall size of PSA will be display like picture below.
Double click on PSA line to display detail of each datasource. Sort the size in order to see the biggest table.
To find the name of datasource. Go to SE16 - RSTSODS and enter BW Object from DB02 into Technical ODS Name. Execute it, the name of datasource will be display
Then, go to check on the flow in process chain. In order to delete the PSA, it has to be deleted by process chain.

How to Delete PSA

Add object 'Deletion of Requests from PSA
Enter parameter for each data source
The time should be:
- Delta loading is 7 days
- Full load is 1 day

Note:
1. The best practice is modified process chain in development system
2. Deletion of PSA should be at the end of process chain.
3. Check the big PSA once a year and if missing process is found, modify the process chain

Task list

Authorization

Meta data

Delete un-used queries & workbooks

Delete un-used Bex Web bookmarks

Delete Bex Broadcaster Bookmarks

Delete un-used workbooks & roles content

Statistics

Delete Temporary Tables - Optional

Deleting DTP Error Log

Deletion of BW Statistics

Delete RSST logs

Clean DYNPSOURCE table

Delete Sent Documents - Hidden documents

Delete Sent Documents - Private Documents

Reorg Documents & Sent requests

Deletion of Log Files - PC Instances

Deletion of Log FILES - Process Chain Log

Deletion of Log Files - Job Status

Deletion of Log Files - Application logs

Delete Idocs

Deletion of Change Log

How to check the biggest table of Change Log

How to Delete Change Log

Business Data

Delete empty, un-used partitions for cubes

Deletion of Aggregates

Deletion of PSA

How to check the biggest table of PSA

How to Delete PSA