Purpose of the offloading analysis is to identify a list of InfoProviders suitable for offloading. Analysis is collecting and evaluating multiple statistics about each InfoProvider in order to reduce your database in easy way. You setup analysis once and just wait for email notification with the results or suggestions. 

Setup

Initial setup consists of two parts. Initial setup of system and BW Analysis setup. 

• Go to transaction /DVD/HS_OFF_SETUP
• Initial system setup
  
  • Install license if needed 
  • Fill customer information
    • Insights customer ID 
      • if you don't have your customer ID you can e.g. number 123
    • Customer name
  • Fill administrator information
    • Email address will be used for receiving notification or results
  • Leave selected 'Only central' deployment scenario
  • Fill central customizing 
    • User name for execution of background jobs
    • Sender's e-mail address for notifications or results
  • Confirm setup with Complete button
  • See setup logs and click Exit
• BW Analysis setup
  • Confirm that system will be added to the system landscape
  • Confirm that you want to continue with BW Analysis setup
  • See setup logs

The analysis is executed immediately after finishing setup. Once the analysis is done and the results are ready, e-mail notification is send to you. Please be aware the analysis can take multiple hours, depending on your database size and system performance. 

Notification email

Once results of the analysis are ready, you will receive notification email with following information:

• size of database that you could save
• list of InfoProviders that fulfill offloading rules
• step list to offload proposed InfoProviders
• criteria used for InfoProvider list creation
• 2 attachments
  • shortcut file to see result in SAP system
  • JSON file with necessary information for offloading

Offloading analysis viewer

Result are available using transaction /DVD/HS_OFFD directly on analysed system. 

InfoProviders that fulfill offloading rules are displayed in results. Following table shows the meaning of particular columns in a result table.

Notification settings

Email address that was set during setup will be receiving notifications about potential offloading candidates. You are able to change delivery parameters as follows:

Find menu Notifications and chose Advanced settings.

List of notification parameters

Offloading rules

InfoProvider are displayed in results only in case it fits to rules. Product installation provides default rule values. However, you can adjust rule values according to your archiving strategy. Here you can find available rules:

Rule values can be changed by clicking on Rules button.

You can define additional "rules" by setting filters to ALV table. When you then hit Save button, all rules are saved together in offloading variant.

Example: How to set additional filter

Choose column which you want to filter

Set select option e.g. all object starts to Z

Confirm and save offloading variant

Offloading variants

Offloading variant contains rule values as well as ALV filters. You can create multiple variants in order to compare different offloading strategies. One offloading variant can be set as default for calculation of notification email and for Actions queue. Default offloading variant cannot be changed, but you can create you own.

Set offloading variant for notifications

Initial installation contains default offloading variant that is used for notifications. If you want to get notifications based on your own offloading variant, proceed as follows.

Notifications > Set current variant

Offloading interface availability

Offloading analysis can recommend two offloading interfaces for object:

Interface is recommended by multiple criteria. Here you can find the main criteria:

• System prerequisites required by interface implementation
• InfoProvider type support
• InfoProvider requirements to interface
  • special functions e.g. WRITER

Export configuration

If you choose InfoProviders that should be offloaded, you can select them and export their offloading related configuration into file. This file can be then imported to the development system in order to create offloading DataProviders. There are two ways to get the configuration:

• Notification email contains a configuration file
• Download configuration file from the result viewer
  • choose object that you want to export (if nothing is selected everything is exported)
  • click on button Export configuration

Information how to add DataProviders using configuration JSON file can be found here: (2008) DataTiering Main Screen (find Define DP from file)