Purpose of offloading analysis is to identify 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 results or suggestions. 

Setup

Initial setup consist 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 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 system landscape
  • Confirm that you want to continue with BW Analysis setup
  • See setup logs

Analysis is executed immediately after finishing setup. Once analysis is done and results are ready e-mail notification is send to you. Please be aware that 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 fulfil 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 offloadnig

Offloading analysis viewer

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

InfoProviders that fulfil offloading rules are displayed in results. Following table show meaning of particular columns in 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

In o

Offloading rules

InfoProvider are display 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 click on Rules button.

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

Example: How to set additional filter

Chose 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 notification. 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 main criteria:

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

Export configuration

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

• Notification email contains configuration file
• Download configuration file from result viewer
  • chose 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 you can find here: (2002) DataTiering Main Screen (find Define DP from file)