...
- 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:- Subgroup ID - unique identifier of data distribution analysis.
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.
Info 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.
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.
Click on save button to save data distribution analysis definition.
- 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.
- Execute /DVD/MON transaction on central system.
- Click on "Monitoring settings" in Settings menu of the transaction.
- In the tree on left side of the screen double click on "KPI collectors" folder.
- In displayed list of collectors search for "/DVD/MON_HM_CL_COL_DU" collector and select its row.
- While the collector row is selected double click on "Collector's inputs" folder in the left tree.
- In displayed list of collector input tables click on "Display/Change" button for input table "/DVD/HS_IT_DU1".
- In table maintenence view switch to edit mode.
- Click on create new record button.
- Fill new row while providing:
- Subgroup ID - Same ID as was defined for data distribution analysis definition in step 1.
Number - number of days to update size data of data groups.
Note 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.
- Click on Save button.
New data distribution analysis is now defined.
- 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.
Results can be seen in Fiori frontend of Insights application.
...
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
...
- 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"
...
