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. You can schedule this object, and then it controls the data-loading process from the source system. InfoPackages can be controlled externally 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

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. You can see the individual processes 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.

See also: