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	Careful : Delete only if these do not correspond to documentation workbooks
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	Careful : Delete only if these do not correspond to documentation workbooks
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)