Checking the Delta Queue

The delta queue is a data store in the source system into which data records are automatically written using a update process in the source system (such as with FI documents) or using extraction using a function module after a data request from the BW (such as LIS extraction prior to BW 2.0).

With a delta request, the data records are transferred from the Scheduler into BW.

The data is stored in compressed form in the delta queue. It can be requested from several BW systems. The delta queue is also repeat enabled; it stores the data from the last extraction process. The repeat mode of the delta queue is specific to the target system.

If the extraction structure of a DataSource is changed after data is written into the delta queue but before the queue data is read (for example, when you upgrade), you can tell which structure in the delta queue the data was written to from the data itself. The queue monitor contains fields that were not filled before but are now filled and/or fields that were filled before but are no longer filled.

You use this function to check the delta queue.

The status symbol indicates whether the update into a delta queue is activated for a DataSource. The delta queue is activated if the status symbol is green. In other words, it is filled with data records when an update or data request takes place from the BW. Prerequisite for a delta update is a successful execution of the delta method initialization in the BW Scheduler.

You can carry out the following activities:

• Display data records
• Display the current status of the delta-relevant field
• Refresh
• Delete the queue
• Delete queue data

Display data records

1. To check the amount and type of data in the delta queue, select the delta queue and choose Display Data Records.
2. A dialog box appears in which you can specify how you want to display the data records.
   1. You can select the data packages that contain the data records you want to see.
   2. You can display specific data records in the data packages.
   3. You can simulate the extraction parameters to select how you want to display the data records.
3. To display the data records, choose Execute.

Display the current status of the delta-relevant field

For DataSources that support generic deltas, you can display the current value of the delta-relevant field in the delta queue. In the Status column, choose Detail. The value displayed includes the largest value for the last extraction with reference to the delta-relevant field. It is the lower limit for the next extraction.

Refresh

If you select refresh,

• newly activated delta queues are displayed
• new data records written to the delta queue are displayed
• data records that have been deleted by the time the system reads the data records are not displayed

Delete queue data

To delete the data in a delta queue for a DataSource, select the delta queue and, in the context menu, choose Delete Data.

If you delete data from the delta queue, you do not have to reinitialize the delta method to write the DataSource data records into the delta queue.

Delete the queue

You can delete the entire queue by choosing Queue  →   Delete Queue. You need to reinitialize the delta method before you can write data records for the related DataSource into the delta queue.