Delta Queue Check 

Use

The delta queue is a data store in the source system into which data records are written automatically. The data records are written to the delta queue either using an update process in the source system (for example with FI documents) or are extracted using a function module when data is requested from BI (for example, LIS extraction prior to BW 2.0).

With a delta request, the data records are transferred into BI from the scheduler.

The data is stored in compressed form in the delta queue. It can be requested from several BI 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.

Features

The status symbol shows whether an update into a delta queue is activated for a particular DataSource. The delta queue is active if the status symbol is green; it is filled with data records when there is an update process or data request from BI. The delta method has to be initialized successfully in the scheduler in BI before a delta update can take place.

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

Activities

Displaying 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.

                            a.      You can select the data packages that contain the data records you want to see.

                            b.      You can display specific data records in the data package.

                            c.      You can simulate the extraction parameters to select how you want to display the data records.

       3.      To display the data records, choose Execute.

Displaying Current Status of 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.

Refreshing

If you select refresh,

●      newly activated delta queues are displayed

●      new data records that have been 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

Deleting 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.

Note that data is also deleted that has not yet been read from the delta queue. As a result, any existing delta update is invalidated. Only use this function when you are sure that you want to delete all queue data.

Deleting Queues

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.