(DI-1802) BW add-on 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 /wiki/spaces/ITOA/pages/14700282 for how to execute data distribution analysi).

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.

Replication of data can be done only on central system after BW data usage collector (included in HMBW_1DAY monitoring profile) succesfully collected and transfered analysis data from desired satellite system. You can check it by transaction /DVD/HS_SUBGVIEW with specified system ID and subgroup.

Delete data distribution statistics

The report /DVD/HS_CENTRAL_DEL_SDATA can be used to delete tables used for Data distribution analyses. Data older than the entered date are deleted. The system always adds one day to the enter date. The Subgroup ID is by default pre-filled as standard.

When you run the report without selecting Delete data in satellite, the tables /DVD/HS_R_KPI_S and /DVD/HS_R_SUB_S are deleted only in the central system. By selecting the checkbox, also data of the satellite systems is deleted (tables /DVD/HS_R_KPI and /DVD/HS_SUB_QS are deleted in the satellite system).

After the report is executed, the result displays the number of deleted data in all tables.