Connection to SAP Business Information Warehouse 

Purpose

You connect SAP Event Management (SAP EM) to SAP Business Information Warehouse (SAP BW) to transfer your supply chain event management-relevant data to SAP BW. In this way, you can evaluate this data in SAP BW analytically.

For example, you can create key figures on:

·         The punctuality of your supplier

·         Adherence to planned shipment and delivery times

·         Customs processing

You use the following as data sources:

·        The event handlers and their related information (info parameters, control parameters, event handler header, and event handler extension structure)

·        The expected events

·        The stored process flow for the expected events

·        If required, unexpected events that have been reported

 

Integration

The following figure provides an overview of integrating SAP EM to SAP BW:

You have made the general settings for extracting data in Customizing for SAP EM. Examples of these settings include the update mode and configuring if and when the SAP BW upload is automatic.

You want to transfer data belonging to an event handler to SAP BW.

SAP EM determines the event handler type of this event handler. The event handler type determines the SAP BW profile. You use this SAP BW profile to define the extraction level. For example, you define the event handler header level and event level as well as mapping event handler and event information to the extraction structures of the relevant extraction levels. After the data has been transferred, you can determine and query key figures in SAP BW.

 

Prerequisites

·        You have configured SAP EM for the initial and the delta upload:

¡        You have defined an event that uses the activity to trigger the SAP BW upload in SAP EM.

¡        You have specified that the event should be posted automatically for the delta upload. This ensures that the BW upload is updated automatically.

¡        You have executed Customizing for SAP BW in SAP EM by:

§         Creating a SAP BW profile with the required extraction level

For more information on defining SAP BW profiles, see the documentation for the Implementation Guide (IMG) for Event Management ® SAP Business Information Warehouse Interface ® Define SAP BW Profiles.

§         Assigning the SAP BW profile to an event handler type

For more information on configuring SAP EM for the SAP BW upload, see the documentation for the Implementation Guide (IMG) for Event Management ®  SAP Business Information Warehouse Interface ®  Process for Extracting BW Data.

·        You have configured SAP BW.

For more information on configuring SAP BW, see the documentation for the Implementation Guide (IMG) for Event Management ® SAP Business Information Warehouse Interface ® Process for Extracting BW Data.

Process Flow

       1.      You define the following in Customizing for the SAP BW profile:

...

                            a.      The source structures and tables in SAP EM that contain the data that you want to transfer to SAP BW.

You want to send data for the events Departure and the Arrival at Customer for your service provider to SAP BW, for example. You specify the event handler header /SAPTRX/EH_HDR and the table for expected events /SAPTRX/EH_EXPEV as your source structures.

                            b.      How the source structures/tables are mapped onto the extraction structures.

The event that you have defined to trigger the SAP BW upload calls a function module that evaluates the actual data for each event handler and fills the extraction structures in accordance with the Customizing settings you made for mapping.

If you defined an automatic delta upload in Customizing for mapping, the data is updated automatically in SAP BW.

       2.      SAP provides DataSources that are defined using extraction structures.

SAP EM updates the DataSources:

¡        Using a set up table for an initial upload

¡        Directly using the delta queue for a delta upload

The data is available to SAP BW after the DataSources have been updated.

       3.      The system maps the DataSources one-to-one onto the InfoSources.

SAP BW provides the corresponding InfoSources.

       4.      SAP BW maps the InfoSources one-to-one onto the operational data storage (ODS).

       5.      SAP BW collects the ODS data in InfoCubes that are delivered with visibility scenarios.

       6.      You can use queries to evaluate the data in InfoCubes. SAP delivers example queries with the visibility processes.

The following figures provide an overview of the process flow: