(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).

  1. After execution of the '/DVD/HS_CENTRAL_VIEWER' program following screen is displayed.
  2. Click on  button.
  3. 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.)


  4. 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:

ParameterDescription
System IDSystem ID used as source
Subgroup IDSubgroup ID used as source
Run IDRun ID where data will be replicated
Run ID descriptionDescription of newly created Run ID
Cost of GBCost of one GB occupied on the system
CurrencyCost 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) successfully collected and transferred analysis data from desired satellite system. You can check it by transaction /DVD/HS_SUBGVIEW with specified system ID and subgroup.

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

ParameterDescription
Delete data in the centralData 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 systemAll 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 satelliteData 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 systemAll 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.