(DI-1708) Appendix B: How to define data distribution analysis

Owned by Veronika Hunorova (Unlicensed)
Last updated: Aug 15, 2017
5 min read

Insights BW module enables you to analyze data distribution and usage of InfoProviders in particular system based on any characteristic. Current version of BW module support analysis based on only one specified characteristic.

There is one exception to this rule. BW module is shipped with one predefined data distribution setting with technical name "STANDARD". This data distribution does not use only one specific characteristic to split data in InfoProviders. It uses set of standard time characteristics (0CALYEAR, 0CALMONTH, 0CALWEEK, 0FISCYEAR, 0FISCPER, 0CALDAY). Each InfoProvider is searched for one of these characteristics (from left to right order) and then data distribution is done using the first one found while values are transformed to years level.

Data distribution definition (new analysis)

You can define new analysis for data distribution of your monitored system InfoProviders following steps described in this section. This will result in creation of a new tile in Insights Fiori frontend in "Data Management" area.

Custom data distribution analysis tile

  1. To define new data distribution analysis (technically called as Subgroup) run transaction SE38 and execute program "/DVD/HS_CENTRAL_SUBGROUP". Following screen will be displayed. 

    In this screen you need to define following data distribution analysis attributes:
    1. Subgroup ID - unique identifier of data distribution analysis. 

    2. Split Characteristics - Here you define what InfoObjects will be used for creation of data distribution analysis. In current version only 1 characteristic can be defined and used in data distribution. What will happen during analysis is that each analyzed InfoProvider will be searched if it does contain that characteristic. If characteristic is found all InfoProvider data are split to the groups created based on distinct values of this characteristic. 

      There is safety check that allows to split object data only up to 100 distinct values to prevent too much data generation in the system.

    3. Data groups definition area - in this table you can define data groups. Each data group is identified by its id (first column). It has its own description and then set of conditions. These conditions define how InfoProvider data groups created by split using specified characteristic will be grouped in Fiori analysis output.

  2. Click on save button to save data distribution analysis definition. 

  3. If you would refresh Fiori frontend of Insights now you should see new tile there already but without data. To execute analysis we need to add this new data distribution to our collector.
  4. Execute /DVD/MON transaction on central system.
  5. Click on "Monitoring settings" in Settings menu of the transaction.
  6. In the tree on left side of the screen double click on "KPI collectors" folder. 
  7. In displayed list of collectors search for "/DVD/MON_HM_CL_COL_DU" collector and select its row.
  8. While the collector row is selected double click on "Collector's inputs" folder in the left tree.
  9. In displayed list of collector input tables click on "Display/Change" button for input table "/DVD/HS_IT_DU1".
  10. In table maintenence view switch to edit mode.
  11. Click on create new record button.
  12. Fill new row while providing:
    1. Subgroup ID - Same ID as was defined for data distribution analysis definition in step 1.

    2. Number - number of days to update size data of data groups. 

      Data distribution analyses collector is executed every day for all defined data distribution analyses. Doing size update of all InfoProviders data everyday would not be possible due to long runtime of this action. Therefore it is recommened to update sizes of data in InfoProviders only once per some period. Minimal recommended value is two weeks. Update of usage of InfoProvider data is done everyday as it is much faster.


  13. Click on Save button.

  14. New data distribution analysis is now defined.

  15. Analysis will be automaticaly executed on all systems where Data Distribution Collector is schedulled. See BW add-on setup section on how to schedule collector.

  16. Results can be seen in Fiori frontend of Insights application. 

Please note that collector always gathers analysis results from monitored system created on its previous run (if already finished). Therefore first results will be visible in Fiori frontend day after first run of analysis is finsihed on monitored system

Example

Here is example how would be one InfoProvider data processed whith data distribution specified as in previous step list. We will use /DVD/IC_CUBE InfoProvider as example that contains characteristic 0CURRENCY.

Analysis will find this characteristic in structure of InfoProvider and will select all distinct values while calculating their respective sizes. Lets pretend that InfoProvider has size of 10 GB in total. Results of such split would be in our example following:

  • 0CURRENCY - EUR - 1 GB 
  • 0CURRENCY - USD - 3 GB
  • 0CURRENCY - NZD - 3 GB
  • 0CURRENCY - JPY - 2 GB
  • 0CURRENCY - CHF - 1 GB

As we dont want to see results for all available distinct currencies sepparatly we have defined 3 data groups (See step 1 above). The previous results will be assigned to appropriate data groups based on the selection defined for them.

  • Data group 1 - data with 0CURRENCY EUR will belong here (1 GB).
  • Data group 2 - data with 0CURRENCY USD will belong here (3 GB).
  • Data group 3 - will group all other data (6GB).

After execution of collector we can see in Fiori frontend three columns for Data Group sizes and three columns for Data Group usages and not columns for all distinct values sepparatelly. This way we can only focus on usage of data that are important for us. 

Restricting InfoProviders to be analyzed 

As it is not always needed to analyzed all InfoProviders based on some characteristic. You can restrict for which InfoProviders each data distribution analysis should be executed. To restrict specific analysis you need to change input table "/DVD/HS_IT_DU2" of collector in following way: 

  • Add new row to the table with following content
    • Subgroup ID - ID of data distribution analysis in which you want to restrict InfoProviders to be analyzed,
    • Number - Unique number for each new line in the table
    • Object type - INFOCUBE,DSO or ADSO - for type of InfoProvider which selection should be restricted.
    • Select option - Standard select option format to filter on technical name on InfoProvider
  • Bellow is example of new rows that we would add to restrict our CURRENCY data distribution analysis to analyze all DSO and ADSO InfoProviders in the system but only one InfoCube with technical name "/DVD/IC_CUBE"