In several previous blogs I already mentioned that you can bridge data silos and bring external SAP BW data into applications like Business Process Operations dashboards, Dependency Diagrams or Progress Management Board via BEx query. In Business Process Operations dashboards that means that you can report on SAP Solution Manager and SAP BW data in parallel. With the help of Dependency Diagrams you can easily visualize how operational, problem-oriented Business Process Analytics key figures can have an impact on your overarching Business KPIs (e.g. Days Sales Outstanding) which will be measured in SAP BW. The Progress Management Board allows then the progress tracking of Business Process Analytics key figures or SAP BW business KPIs.

This blog explains the steps you need to perform in order to see the external BW data in the above mentioned SAP Solution Manager applications. The description is basically taken from chapter 4.4 of the Best Practice document about Dependency Diagrams (~15 pages in total).

SAP BW Connector Setup

The first step is that you create once a corresponding connector instance, so that the SAP Solution Manager knows which SAP BW system should be connected and which RFC connection should be used.

As of SAP Solution Manager 7.1 SP14 you will find under BPO Reporting Structure the tab for the Data Source Manager. Under Connector you will find the BW Query Connector called BPO_BW_Query.

  1. Go to the Tab Data Source Manager
  2. Select the BPO_BW_Query Connector
  3. Click ‘add’ to configure a Connector Instance to your BW system.
  4. Maintain a Name and a Description for the Connector Instance
  5. Select the Read RFC Connection to your BW system and enter the system Name.
  6. Under Application you add the BPO Dashboards as Application by clicking on ‘Add’
  7. Create your Connector Instance
  8. Save it. If you reload the tab you should see two green lights under Status and Active


New connector instance.png

AKF Setup for BEx query

The next step is to maintain an Analytical Key Figure (AKF) that specifies which BEx query should be used for data retrieval from which Info Provider. This query needs to be defined in SAP BW obviously.

We are still in the same UI where we just created the connector instance and click on the button Maintain BW Query AKF.

  1. Click ‘Add’.
  2. Enter a technical name and a Description.
  3. Select the Connector Instance you created before.
  4. Use the F4 Help to find your BW Query. The Info Cube will be automatically selected if you add the Query.
  5. Use the F4 Help to select the key figure. This is basically the measurement coming from the Query (i.e. the amount of days in this example).
  6. Save.

New AKFI.png

The RFC User maintained in the Read RFC Connection to your SAP BW system for the BEx query needs the following authorizations:

Object

Authorization Field

S_RFC

RFC_TYPE=FUGR

RFC_NAME= RZX0

RFC_NAME=/SDF/E2EEM_COLLECTORS

RFC_NAME=AGS_BPM_RI_CONN;

RFC_NAME=SYST;

RFC_NAME=SUNI;

ACTVT=16

S_RFC

RFC_TYPE=FUNC

RFC_NAME=RSZ_X_COMPONENT_LIST_GET

RFC_NAME=/SDF/E2EEM_GET_DATA

ACTVT=16

/SDF/E2E

ACTVT=03

S_SRT_ELOG

ACTVT=03

S_SRT_PLOA

WS_NAME=*;USR_ACCESS=1;

ACTVT=03

AI_DIAGE2E

ACTVT=03

Use the AKF in the respective SAP Solution Manager application

Now that you created you AKF for the respective BEx query it can be used like any other AKFI that you created previously based on Business Process Analytics. So you can go now into the Business Process Operations setup and assign the new BW AKF to some panel, or you can go into the Dependency Diagram setup and use the AKF as root or child tile, or you assign the AKF to your newly created Progress Management Board.

Further reading

You can find all necessary information about Business Process Analytics in this document. More information on Business Process Improvement for SAP solutions can be found here.

Frequently Asked Questions about Business Process Monitoring and Business Process Analytics are answered underhttp://wiki.sdn.sap.com/wiki/display/SM/FAQ+Business+Process+Monitoring and

http://wiki.sdn.sap.com/wiki/display/SM/FAQ+Business+Process+Analytics respectively.

The following blogs (in chronological order) provide further details about Business Process Analytics and Business Process Monitoring functionalities within the SAP Solution Manager.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply