(DI-1805) BW NetWeaver functions
As Fiori applications cannot be accessed in all customer systems BW add-on provides means to display some of data using SAP NetWeaver. Following data can be accessed using SAP NetWeaver:
- Progression logs of BW add-on collectors (satellite system)
- Data distribution analysis results
- Other analysis results
In following sections each data access is described in more detail.
Progression loggin
As BW add-on collectors can run for multiple hours user can see current progress of collector by running transaction SLG1 on satellite system where collector is currently running. In transaction provide following input parameters:
- Object - /DVD/HS
- Subobject - *
- External ID - *
After pressing execute button (F8) logs of BW add-on collectors should be displayed.
Important
As result of SAP logging mechanism it is possible that log will not be displayed if user tries to access it at the time running process is writing records to it. In such case it is recommended to try to display logs few times to overcome this issue.
Following is example of Data distribution collector processing log.
Data distribution analysis result access
User can access already analyzed data by Data distribution analysis from SAP NetWeaver by running program '/DVD/HS_CENTRAL_VIEWER' in SE38 transaction or in transaction /DVD/HS_SUBGVIEW in the central system (see section (DI-1805) How to define data distribution analysis for how to execute Data distribution analysis).
- After execution of the '/DVD/HS_CENTRAL_VIEWER' program following screen is displayed.
- Click on button.
- Fill out System ID and Data distribution ID in displayed dialog window. (You have to fill the whole System ID or you could in transaction /dvd/mon, Settings/User settings on tab "General" check the checkbox "Display full system ID" and after this setting you will have in F4 help fo field "System ID" the whole name of System ID.)
- Data distribution analysis results will be displayed in ALV table in same format as in Fiori (If they are available for the system).
Other analysis result access
User can access other BW add-on analysis results using program '/DVD/HS_CENTRAL_ANA_VIEWER' through SE38 transaction or transaction /DVD/HS_ANLVIEW on central system. Currently following analyses are capable to display their results in SAP NetWeaver:
- Query runtime analysis
To display analysis result on central system follow these steps:
- Execute '/DVD/HS_CENTRAL_ANA_VIEWER' program through transaction SE38 or transaction /DVD/HS_ANLVIEW. Following screen will be displayed.
- Click on toolbar button.
- Select system (source satellite system of analysis ) and analysis type that you would like to display and confirm selection.
- Appropriate analysis result will be displayed in ALV table on main screen.
Data distribution analysis replication to SAPGUI heatmap visualization
In former version of the product we visualizate data from Data distribution analysis in SAP GUI. As it is not always possible for customer to setup fiori version of product we enabled to see result also in standard SAP GUI. Only thing that needs to be done is replication of data collected by Data distribution analysis. Replication can be done using transaction /DVD/HS_SUBGREPL or directly report /DVD/HS_CENTRAL_REPL_SUB.
Report parameters:
Parameter | Description |
---|---|
System ID | System ID used as source |
Subgroup ID | Subgroup ID used as source |
Run ID | Run ID where data will be replicated |
Run ID description | Description of newly created Run ID |
Cost of GB | Cost of one GB occupied on the system |
Currency | Cost currency |
After successful replication data are available for fruther analysis using transaction /DVD/HS_ANALYZE.
Deleting tables used in the Data distribution analysis
The report /DVD/HS_CENTRAL_DEL_SDATA can be used to delete tables used for data distribution analyses. After you run the report the below dialog appears with default settings. The default date is the system date plus one day. Data older than the this date is deleted. The Subgroup ID is by default pre-filled as STANDARD. System ID needs to be picked using the F4 help.
Before the execution you must stop the collector with the profile HMBW_1DAY, as the following jobs cannot be active during the execution of the report.
HM_COL_[Subgroup ID]_AGG_JOB
HM_COL_[Subgroup ID]_JOB
Input parameters
Parameter | Description |
---|---|
Delete data in the central | Data is deleted from the tables /DVD/HS_R_KPI_S and /DVD/HS_R_SUB_S in the central system based on parameters you entered in the above fields |
Delete ALL - central system | All data is deleted from the tables /DVD/HS_R_KPI_S and /DVD/HS_R_SUB_S in the central system |
Delete data in the satellite | Data is deleted from the tables /DVD/HS_R_KPI, /DVD/HS_R_SUB and /DVD/HS_SUB_QS in a satellite system based on parameters you entered in the above fields |
Delete ALL - satellite system | All data is deleted from the tables /DVD/HS_R_KPI, /DVD/HS_R_SUB and /DVD/HS_SUB_QS in a satellite system |
After the report is executed, the result displays the amount of deleted data in all tables.