BW Housekeeping Tasks
Prior to a migation from BW on RDBMS to BW on HANA, which are the key clean-up, housekeeping task we need to consider?
As the system tables in BW on HANA are all stored on the Master Node, it might become important to clean up the PSA and Change Log tables, in order to not exceed the size of the hardware used for your master node.
Also with regards to ensure proper sizing, and therefore to avoid the migration of unnecessary data, it is highly recommend to follow the recommendations describe in this link on SDN:
Please also see these SAP Notes:
Preventing Basis tables from increasing considerably: http://Service.sap.com/sap/support/notes/706478
Database migration: Report to find large row store tables: http://Service.sap.com/sap/support/notes/1634681
SAP BW on HANA DBA aspects:
How to maintain table RSBATCHDATA?
Please see link to SDN: