Infoset Delta Extraction

[Former Member]

Hi,

I just want to find out if delta can be set up on Infoset query extraction into BW. I am able to do Initialisation and full load but not Delta. Timestamp has taken as Delta pointer. In extract checker I see the delta records but not in Delta Queue. Do I have to set up anything else to have Delta set up into BW?

Thanks.

[Former Member · Accepted solution]

Hi Romana,

Have you set up the Safety interval for your delta extraction?

3. Maintain the settings for the generic delta:

a. Specify a security interval.

The purpose of a security interval is to make the system take into consideration records that appear during the extraction process but which remain unextracted (since they have yet to be saved) during the next extraction.

You have the option of adding a security interval to the upper limit/lower limit of the interval.

A security interval should only be specified for the lower limit when the delta method results in a new status for changed records, in other words, when the status is overwritten in BW. In this case, duplicate data records that could arise in such a safety interval have no affect on BW.

b. Choose the delta type for the data to be extracted.

The delta type is used to determine how extracted data is interpreted in BW and which data targets in which it can be posted.

With the delta type additive delta, the record to be loaded for summarizable key figures only returns the change to the key figure. The extracted data is added in BW. DataSources with this delta type can supply both ODS objects and InfoCubes with data.

With the delta type New Status for Changed Records, every record to be loaded returns the new status for all key figures and characteristics. The values are overwritten in BW. DataSources with this delta type can write the data into ODS objects and master data tables.

4. Save your entries.

Delta transfer is now possible for this DataSource.

After generating the DataSource, you can see this from the marking for the field Delta Update on the DataSource: Customer Version screen.

In systems from release 4.0B, you can display the current value of the delta-relevant field in the delta queue. Go through the help below.

Example for Determining the Selection Interval for a Generic Delta

Safety Interval Upper Limit

The delta-relevant field is a timestamp.

The timestamp that was read last is 12:00:00. Delta extraction begins at 12:30:00. The safety interval for the upper limit is 120 seconds. The safety interval for the delta request is: 12:00:00 to 12:28:00. Upon completion of the extraction, the pointer is set to 12:28:00.

Safety Interval Lower Limit

The delta-relevant field is a timestamp. After images are transferred. In other words, the record is overwritten with the status after the change in BW, for example for master data. Any duplicate records that appear have no effect upon the BW system.

The last changed timestamp is 12:28:00. Delta extraction begins at 13:00. The safety interval for the lower limit is 180secs. The safety interval for the delta request is: 12:25:00 to 13:00:00. Upon completion of the extraction, the pointer is set to 13:00:00.

[Former Member · Accepted solution]

Hi,

Yes, we did set up the safety intervals, still not showing up. Please let em know if you have any other thoughts.

Thanks.

[Former Member]

Hi,

Does Generic datasources show up in Delta Queue?

Regards