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)

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

4 - Select All bookmarks and delete

Repeat

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

V7 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

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"

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

When to do

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

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

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"

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

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

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

Main tables cleaned
RSPCLOGCHAIN RSPCPROCESSLOG

Deletion of Log Files - Job Status

Already scheduled

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

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

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

Authorization

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

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"

5 - Check the result of the analysis

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

Deletion of un-used / inefficient aggregates

1 - Go to RSA1 transaction

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

3 - Analyse each aggregate to see if it is useful

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"

7 - Select the aggregate, right click and delete

Page tree

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

Business Data

Delete empty, un-used partitions for cubes

Deletion of un-used / inefficient aggregates

Page tree

House Cleaning Procedure

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

Business Data

Delete empty, un-used partitions for cubes

Deletion of un-used / inefficient aggregates