Show TOC

Extracting Data to SAP NetWeaver Business WarehouseLocate this document in the navigation structure

Use

SAP NetWeaver Business Warehouse (BW) provides mechanisms for extracting data, which is performed at BW's request (pull). Data can be extracted from various systems, called source systems. Data extraction is the operation of taking data from the operational source system and transferring it to the BW system. SAP NetWeaver Business Process Management (BPM) data is extracted using a UD (Universal Data) connect system and delta extraction is supported, which means that only data changed after the last extraction is extracted again.

Integration between BPM and BW enables reporting on both generic process data and process context data. Data is extracted from the operational source system using UD Connect DataSources for master and transaction data. The extractors providing data from the source system support delta extraction for all transaction and master data DataSources. Data is subsequently used for updating the relevant BI content objects, which are various information structures in the BW system.

Note

You can find the current version of BI content documentation on SAP Help Portal, under Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Next navigation step BI Content End of the navigation path.

Transaction Data

The following types of transaction data are provided by BPM extractors:

  • Transaction data based on process and task instances' current state information

  • Data extracted from the business log containing historical information regarding various life cycle events

Transaction data is extracted from the source system on a regular basis, for example once a day. Then, the data from the DataSources is updated into respective DataStore objects that can be used for reporting on instance level. Next, the data from the DataStore objects is aggregated into several InfoCubes that support reporting on various dimensions such as definition, status, priority, and so on, and provide additional key figures.

Master Data

Master data DataSources are used to extract data concerning process and tasks definitions, user data, and texts. Process and task definition master data and texts are not subject to regular changes in a productive system. Thus, their extraction and the update of the respective info provider can be scheduled when new process definitions or new process versions are deployed on the source system. The extraction of texts for process and task instances should be scheduled regularly to obtain the data needed for reporting on instance level.

Extraction of DataSources

Since delta extraction is supported for BPM DataSources, you need to extract the DataSources on a regular basis as follows:

  • Upon deployment of a new process definition or a new version of a process, you extract the following DataSources:

    • Definition Texts (SAP NetWeaver BPM Master Data)

    • Definition Version Texts (SAP NetWeaver BPM Master Data)

    • Definition Version Attributes (SAP NetWeaver BPM Master Data)

  • On a daily basis, you extract the following DataSources:

    • BPM Business Log

    • Principal Assignment Log Events

    • Principal Assignment

    • Task Log Events

    • Task Instance Texts (SAP NetWeaver BPM Master Data)

    • Task Instances

    • Process Log Events

    • Process Instance Texts (SAP NetWeaver BPM Master Data)

    • Process Instances

    • Principal Attributes (SAP NetWeaver BPM Master Data)

Update of Info Providers

After the DataSource extraction, the respective info providers are updated as follows:

  1. SAP NetWeaver BPM Master Data

    Upon deployment of a new process definition or a new version of a process:

    • Definition Version (Attribute)

    • Definition Version (Texts)

    • Definition (Texts)

    On a daily basis:

    • BPM Object (Attribute)

    • BPM Object (Texts)

    • Principal (Attribute)

    • Principal (Texts)

  2. DataStore Objects

    • Business Log Events

    • Principal Assignment

    • Principal Assignment Log Events

    • Process Instances

    • Process Instances Log Events

    • Task Instances

    • Task Instances Log Events

  3. InfoCubes

    • Aggregated Log Events Data

    • Aggregated Process Data

    • Aggregated Task Data

Prerequisites

You have configured the necessary settings to enable communication between the Application Server Java (AS Java) system, where the process model is deployed and the BW system. For more information, see Configuring BPM-BW Connectivity .

Procedure

1. Create a UD Connect Source System

  1. In the BW system, enter /nrsa1 in the search area and press ENTER .

  2. In the Data Warehousing Workbench, select Source Systems under Modeling and in the context menu of the UD Connect folder, choose Create .

  3. Select the required RFC Destination for the AS Java.

  4. Specify a logical system name.

  5. Leave the Type of Connector field blank.

  6. In the Name of Connector field, select SDK_JAVA .

  7. Specify the name of the source system if it was not determined from the logical system name.

  8. In the Type and Release field, enter BPM720 .

  9. Choose Continue.

2. Install the BI Content

You install the BI content, that is, you activate it to be able to load data in the different BI content objects. BPM provides BI content for the generic process data.

Note

BPM BI content objects are included in package RS_BCT_GLX - SAP NetWeaver BPM BI Content Objects.

For more information about installing BI content, see Copying BI Content to the Active Version on SAP Help Portal under Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver 7.0/7.01 Next navigation step SAP Library Next navigation step SAP NetWeaver Library Next navigation step SAP NetWeaver by Key Capability Next navigation step Information Integration by Key Capability Next navigation step Business Intelligence Next navigation step Data Warehousing Next navigation step Data Warehouse Management Next navigation step Transporting BI Objects, and Creating, Delivering, and Copying BI Content Next navigation step Copying BI Content to the Active Version End of the navigation path.

3. Trigger Data Extraction and Update of BPM Info Providers

To be able to use the delta extraction, you have to use the info packages provided with the respective DataSources. To update BPM info providers, you have to use the data transfer processes (DTP) for the respective info provider.

For more information, see:

  • Scheduling InfoPackages on SAP Help Portal under Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver 7.0/7.01 Next navigation step SAP Library Next navigation step SAP NetWeaver Library Next navigation step SAP NetWeaver by Key Capability Next navigation step Information Integration by Key Capability Next navigation step Business Intelligence Next navigation step Data Warehousing Next navigation step Data Warehouse Management Next navigation step Scheduler Next navigation step Scheduler (3.x) Next navigation step Scheduling InfoPackages End of the navigation path.

  • Creating Data Transfer Processes on SAP Help Portal under Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver 7.0/7.01 Next navigation step SAP Library Next navigation step SAP NetWeaver Library Next navigation step SAP NetWeaver by Key Capability Next navigation step Information Integration by Key Capability Next navigation step Business Intelligence Next navigation step Data Warehousing Next navigation step Data Distribution Next navigation step Data Transfer Process Next navigation step Creating Data Transfer Processes End of the navigation path.

  • Further Processing of Data in DataStore Objects on SAP Help Portal under Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver 7.0/7.01 Next navigation step SAP Library Next navigation step SAP NetWeaver Library Next navigation step SAP NetWeaver by Key Capability Next navigation step Information Integration by Key Capability Next navigation step Business Intelligence Next navigation step Data Warehousing Next navigation step Further Processing Data Next navigation step Further Processing of Data in DataStore Objects End of the navigation path.

  • Further Processing of Data in InfoCubes on SAP Help Portal under Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver 7.0/7.01 Next navigation step SAP Library Next navigation step SAP NetWeaver Library Next navigation step SAP NetWeaver by Key Capability Next navigation step Information Integration by Key Capability Next navigation step Business Intelligence Next navigation step Data Warehousing Next navigation step Further Processing Data Next navigation step Further Processing of Data in InfoCubes End of the navigation path.

You can also use process chains to update data in the BW system. For more information, see Including DataStore Objects in Process Chains on SAP Help Portal under Start of the navigation path http://help.sap.com Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver 7.0/7.01 Next navigation step SAP Library Next navigation step SAP NetWeaver Library Next navigation step SAP NetWeaver by Key Capability Next navigation step Information Integration by Key Capability Next navigation step Business Intelligence Next navigation step Data Warehousing Next navigation step Further Processing Data Next navigation step Further Processing of Data in DataStore Objects Next navigation step Including DataStore Objects in Process Chains End of the navigation path.