BW Information Integration

Business Warehouse (BW) Information integration provides companies with structured and unstructured information that is consistent and accessible. Users have constant access to consistent information, no matter where it is stored. Information Integration includes key capabilities such as Business Intelligence (BI), BI Content, Knowledge Management, and Search and Master Data Management.

This page includes the following:

Scheduling Data-Loading Processes

In an SAP Business Warehouse (BW) system, an InfoPackage is an object that contains the selection criteria and conditions for requesting data from a source system. This object can be scheduled and then it controls the data-loading process from the source system. InfoPackages can be externally controlled by using a standard interface. The AE uses this interface through specific SAP Job Control Language (JCL) commands such as BW_ACTIVATE_INFOPACKAGE, BW_GET_INFOPACKAGES, and BW_SET_INFOPACKAGE_SELECTION.

AE-JCL for SAP

BW_ACTIVATE_INFOPACKAGE

Schedules one or more InfoPackages for immediate start.
BW_GET_INFOPACKAGES

Reads InfoPackages from the BW system. Available InfoPackages are stored in the activation report or a file.
BW_SET_INFOPACKAGE_SELECTION

Sets selection parameters which are used for reading the InfoPackages from the BW system.

Scheduling Process Chains

In your Business Warehouse (BW) system, you can have sequences of processes organized in process chains. Such a process chain includes a start process, individual application processes, and the collection processes. You can also include InfoPackages. You can use your AE system to start and monitor process chains. The individual processes are shown in the Process Monitoring perspective. Process logs are stored in the report of the relevant AE Job object.

AE-JCL for SAP

BW_ACTIVATE_CHAIN

Starts a process chain, monitors its execution and stores the corresponding logs in the activation report.
BW_GET_CHAINS

Reads process chains from the BW system. Available process chains are stored in the activation report or a file.
BW_RESTART_CHAIN

Continues an aborted process chain.

Scheduling Queries in Batch Mode

In your Business Warehouse (BW) system, you can create query extracts by using the RSCRM_BAPI transaction. The result of such a query is either stored in a table or in a file. Your AE system allows you to schedule your queries regularly or upon request.

Procedure

Log on to your BW system and call the RSCRM_BAPI transaction. Select the query that you want to automate with your AE system, and set it to be scheduled once. Open the batch monitor and copy the unique batch ID of your query.
Create an SAP job. Use the Form view or write the following function directly to the Process page of this job:

R3_ACTIVATE_REPORT REP='RSCRMREPORT_BAPI'

Switch to the SAP page and enter the batch ID that you have copied in the Job Name field. For details, see SAP ABAP, Java and PI.

You can now integrate your Job object in your automatic processing, for example, by using a Schedule object. The Schedule object then processes your query at the point in time that you define. For details, see Schedules (JSCH).

Note: SAP behavior has the batch monitor display only the last query execution.