Transferring Master Data from SAP Source Systems

To synchronize master data and transaction data when using real-time data acquisition, you also have to be able to transfer master data to BW using real-time data acquisition. If master data and transaction data are not synchronized, the navigation attributes for the data may be missing or incorrect.

If you use real-time data acquisition to load the master data of a characteristic, you can no longer use the navigation attributes of the characteristic in aggregates. This is because aggregates cannot react to real-time updates, since the change run in the RDA process is not triggered automatically for the loaded data.

The DataSource is delta enabled and supports real-time data acquisition. For your source system, you have installed BW Service API Status SAP NetWeaver 7.0 (Plug-In-Basis 2005.1) or higher, or Plug-In 2004.1 SP10 for release 4.6C.

You can only load master data to an InfoObject using real-time data acquisition if the InfoObject supports this. You can make this setting in InfoObject maintenance. More information:Tab Page: Master Data/Texts.

This section describes how to use real-time data acquisition transfer data from a text or attribute DataSource to an InfoObject :

1. Activate the required DataSource from BI Content and replicate the DataSource in the BW system if necessary.

   SeeInstalling BI Content DataSources in Active Version.

2. If no suitable InfoObjects exist, create one.

   See:Creating InfoObjects: Characteristics

3. Create a transformation with the DataSource as the source and the InfoObject as the target.

   SeeCreating Transformations.

4. Create a data transfer process for real-time data acquisition with the DataSource as the source and the InfoObject as the target.

   SeeCreating Data Transfer Processes for Real-Time Data Acquisition.

5. Create an InfoPackage for the DataSource for simulating the delta initialization and perform delta initialization.

   SeeCreating InfoPackages.

6. Perform delta initialization.
7. If you have transferred data during delta initialization, execute the following steps. Otherwise, proceed to step 10.
8. Post the data from the PSA to the InfoObject.
   1. Go to the maintenance screen for the data transfer process that you created in step 4.
   2. Choose Change to Standard DTP.
   3. On the Execute tab page, start the data transfer process.
9. When the data is successfully loaded into the InfoObject, change the type of the data transfer process again.

   In the maintenance screen for the data transfer process, choose Change to Real-Time DTP.

10. Create an InfoPackage for real-time data acquisition.

    SeeCreating InfoPackages for Real-Time Data Acquisition.

11. On the Scheduling tab page in InfoPackage maintenance, choose Assign Daemon or Call RDA Monitor.

    The Monitor for Real-Time Data Acquisition appears.

12. If required, create a new daemon by choosing Create Daemon.
13. Assign the DataSource (and the InfoPackage) to the daemon.

    The InfoPackage appears in the monitor for real-time data acquisition. The system displays the InfoPackage in the Unassigned Objects area, under the DataSource that the InfoPackage was created for. In the context menu for the DataSource, choose Assign Daemon to assign the InfoPackage to a daemon. The daemon can now use the InfoPackage for data extraction.

14. Assign the data transfer process to the daemon.

    To do this, choose Assign DTP in the context menu for the DataSource, The daemon uses the data transfer process to process data.

    You can post the data from the DataSource to multiple InfoObjects. In this case, assign the corresponding data transfer process to the daemon (using the DataSource).

15. In the monitor for real-time data acquisition, start the daemon.

    To do this, choose Start in the context menu for the daemon.

    The daemon waits for a free background job.

While the background job is running, the daemon starts the delta transfer using the InfoPackage for real-time data acquisition. The daemon executes three steps:

1. In the first step, the daemon calls the service API in the source system. The Service API transfers the data records into BW and then passes them to the daemon. The data is posted to the PSA table.
2. In the second step, when the data has been posted to the PSA table, the daemon confirms this, and the service API changes the status of the records in the delta queue.

   Once the request has been closed, and the next request is open, the records are deleted from the delta queue.

3. In the third step, the daemon starts the data transfer process(es) for real-time data acquisition. This posts the data from the PSA table to the InfoObject's attribute or text table. The request that transfers the data into the PSA table (PSA request) and the DTP request have a 1:1 relation.

The data is now available for analysis and reporting purposes.