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

Main ParameterValue
Last Use Datecurrent 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

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

Main parameterValue

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 :

SectionExplanationAction
Incorrect References from Workbooks in RolesReferences from workbooks in roles that do not exist in workbook storageDelete all
Workbooks without Query Assignment References to workbooks in roles that do not have a query assignmentDO NOT DELETE
Incorrect References from Workbooks in FavoritesReferences from workbooks in favorites that do not exist in workbook storageDelete all
References from workbooks in favorites that do not exist in workbook storageReferences to workbooks in favorites that do not have a query assignmentDO NOT DELETE
Unused WorkbooksWorkbooks in workbook storage that are not referenced in roles or favoritesDelete 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

 

 

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 parameterValue

but always older than ... days

30
delete logChecked
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 parameterValue

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 parameterValue

Ignore Number of Last Days

100
Application AreaBW_BEX
Main tables cleaned

RSTT_CALLSTACK
RSTT_TRACE

 

 

Clean DYNPSOURCE table

1 - Go to transaction SE38

2 - Run program RSDQ_DYNP_GP_CLEANUP

3 - Check the PDOIT

4 - Execute the program

 




Main tables cleaned

DYNPSOURCE

+ corresponding LOB segments

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 parameterValue

Minimum Age (Days)

30
Test ModeUnchecked
Delete documents linkedChecked
Delete unsent documentsChecked
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 parameterValue

Minimum Age (Days)

60
InboxAll
Test ModeUnchecked
Delete unsent documentsChecked

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 parameterValue

Age in days

60 to 9999
Test ModeUnchecked

Deletion of Log Files - PC Instances

1 - Go to SE38

2 - Run program RSPC_INSTANCE_CLEANUP

3 - In Older than : current date - 365

 

Main parameterValue

Older Than

Current Date - 365
Delete LogsChecked

 

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 parameterValue

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

 

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 parameterValue

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

  1. Go to Tcode DB02 
    Select Space --> Additional Function --> BW Analysis. The overall size of change log will be display like picture below.
  2. Double click on ODS & Changelog line to display detail of each DSO. Sort the size in order to see the biggest table. 
     
  3. 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

  1. Add object 'Deletion of Requests from 
  2. 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"

 

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 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 :

  1. If the cube is already in BI Acceletor --> Delete the aggregate as BI Accelerator is used first.
  2. If the valuation of the aggregate is not positive (Ex : |+++ ) then it means it doesn't improve the execution time --> Delete the aggregate
  3. 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 

 

Deletion of PSA

How to check the biggest table of PSA

  1. Go to Tcode DB02 
  2. Select Space --> Additional Function --> BW Analysis.  The overall size of PSA will be display like picture below.
  3. Double click on PSA line to display detail of each datasource. Sort the size in order to see the biggest table.
  4. 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
     
  5. 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

  1. Add object 'Deletion of Requests from PSA
  2. 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