Task list

  • Authorization - Delete un-used BW accounts
  • Meta data - Delete un-used queries & workbooks
  • Meta data - Reorganize workbooks

 

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

Reorganization of workbooks

 

  1. Go to transaction SE38
  2. Run program RSWB_ROLES_REORG
Main tables cleaned
RSRWBSTORE
AGR_HIER
AGR_HIERT
RSRWORKBOOK
SMEN_BUFFC
RSRWBINDEX
RSRWBINDEXT