Delta in generic extractor.

[Former Member]

Hi Everyone,

I have created one of the generic extractor on a table and the other one on a view. While selecting the GENERIC DELTA, I let the numeric pointer selection checked.

Now, my question is will it allow me to do delta load in my cube using this extractor?

2nd question is how?

3rd question is if not then what is the change that I need to make so that it allows me to load the delta load. How this changes need to be made can you please explain step by step. thanks in advance.

My issue arose after loading the data when I went to change the InfoPackage to load the delta part, I realised in my InfoPackage I do not have the choice to load delta. How do I settle this. Actually this is an inventory cube where the data is loaded at the end of each month and now when I wanted to test it for today's month I realised that I do not have the choice to load delta for inventory load.

Please explain. Thank you once again in advance.

[Former Member · Accepted solution]

<u>1. my question is will it allow me to do delta load in my cube using this extractor?</u>

Yes... you build Generic Extractor with Delta based on Numeric Pointer. Material Documents is the Perfect Example for that (We can't Sales Document or Purchase Document for this).

<u>2. 2nd question is how?</u>

Simple enable Material Document Number Fileds for Numeric Pointer (Select Numeric Pointer... provide Mat. Document No. field i.e. MBLNR).

<u>3rd question is if not then what is the change that I need to make so that it allows me to load the delta load. How this changes need to be made can you please explain step by step. thanks in advance.</u>

you need to create Material Documents in SAP R/3. If you build your Extractor on MSEG Table. You need to create any Material Document which populates in MSEG.

I don't remember wht exactly option we will get in Infopackage for Numeric Pointer. To my knowledge, it should give Delta only in Update Tab page.

Hope this helps.

Nagesh Ganisetti.

• Assign points if it helps.

[Former Member]

Hi Jayesh,

1 . Which field have you selected for delta , which is type of the field , generally we select entry date as delta field for generic extractor.

2. System maintains entry of the last extracted data . e.g. in case of date as delta field , system maintains date in the table ROOSGENDLM in sap r/3 side . next time onwards when you load delta system tries to get last extracted date as lowest range and curretn date as highest range.

3. For enabling selection at info package level goto RSA6 -> Locate data source -> Maintain Datasource (Change ) -> Check the box of "selection checkbox" against the month year field .

Hope that helps.

Regards

Mr Kapadia

[Former Member]

Hi,

Check the created data souce and activate once again.

Your creation procedure is correct, check all the objects and activate again and

try.

Regards,

Venkat

[Former Member]

Generic Delta is a Time based Delta, only check if the document selected have the date field (that you selected) greater that the last value load ....in BW theres no difference between generic delta and delta queue....

You can use this to load data in the infocube.

In your infopackage you have the option to load delta only if youir datasource have that choice....if you want your Z datasource to be delta enabled ...change it in RSO2

Regards

[Former Member]

<a href="https://wiki.sdn.sap.com/wiki/display/profile/2007/06/29/Generic+Delta">This</a> may help.