10.3    Weekly, Monthly, Quarterly, and Annual Tasks

In this chapter, we’ve covered many administration tasks that should be executed daily or with another routine frequency. However, this is just the tip of the iceberg; there are many more tasks that should be executed at a less frequent rate, such as weekly, monthly, quarterly, and annually. These tasks are covered in an SAP PRESS book published by some of the same authors as this book, titled SAP BW: Administration and Performance Optimization. Many of these tasks are not specific to SAP BW/4HANA but are applicable to all SAP BW systems, regardless of version.

The following tasks are covered in SAP BW: Administration and Performance Optimization:

• Weekly tasks:
  • Review SAP EarlyWatch Alert
  • Cleanup requests and changelogs
  • Cleanup application logs
  • Execute SAP BW housekeeping task list
  • Execute other housekeeping task lists
  • Execute RSRV consistency checks
  • Monitor BI statistics
  • Monitor cache usage
• Monthly tasks:
  • Schedule system restart
  • Change portal settings
  • Check SAP notes
  • Act on EarlyWatch Alerts
  • Execute RSRV cleanup tasks
  • Forecast storage capacity
  • Conduct file system housekeeping
  • Archive/near-line data
  • Monitor data load statistics
• Quarterly tasks:
  • Manage users and licenses
  • Test system refresh
  • Maintain hardware
  • Update SAP kernel
  • Apply database updates and parameters
  • Patch operating system
  • Validate system parameters
  • Review open transport requests
  • Execute row-store reorganization
  • Delete obsolete queries and reports
  • Delete obsolete data flows
  • Review configuration settings
• Annual tasks:
  • Upgrade SAP BW/4HANA
  • Apply support packs
  • Test high availability and disaster recovery
  • Assess system risks
  • Review data flows
  • Review external performance and optimization