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

Table of Contents:

Setup

Initial setup consists of two parts. Initial setup of the 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 notifications 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 the 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 the BW Analysis setup
  • See setup logs

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

Notification email

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

• Size of the 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 the result in the SAP system
  • JSON file with the necessary information for offloading

Offloading analysis viewer

Results are available using transaction /DVD/HS_OFFD directly on the analyzed system. 

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

Notification settings

The 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 choose Advanced settings.

List of notification parameters

Offloading rules

InfoProvider is displayed in results only in case it fits rules. The 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 the Rules button.

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

Example: How to set an 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 your own.

Set offloading variant for notifications

The initial installation contains the 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 objects:

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 the 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 the object that you want to export (if nothing is selected everything is exported)
  • Click on the button Export configuration

Information on how to add DataProviders using configuration JSON file can be found here: SNP OutBoard™ Data Tiering Main Screen (find Define DP from file).