Skip to Content
author's profile photo Former Member
Former Member

LO Extraction - Delta Questions (Pardon repeat post)

Hi all,

  • Pardon the repeat post, I posted the same q in the 'general' section, just realized that this may be the right area ******************

I read through many previous posts on this topic but still need your help on the following questions. Please do not ask me to search the forum as I've done that already, but still have some specific questions. I will greatly appreciate your pertinent answers and help.

1) What exactly happens during initialization of delta in the LO extraction process? I'm looking for a technical answer - are before images for the records that exist in the setup tables written into the delta queue? Does the system make any settings on the BW side as well?

2) I have a shop floor extractor (application number 04) for which I want to fill the set up tables. I've been told that documents with dates up to November 2007 will not be changed any more.

Question: I will fill setup table giving end date selection as Nov 30, 2007. I will not specify a start date. Will this load all historical records upto Nov 30, 2007? My question basically is - is it ok to not provide a start date in the selection screen of OLI4BW if I want all records prior to Nov 30, 2007?

3) I want to load all historical data into BW first. In the next step I want to load the records with dates Dec 1, 2007 until today and activate delta. What steps should I follow? Can I do the following?

Step 1: Fill set up table with historical data, run full load in BW. I will not worry about locking users here.

Step 2: Fill set up table with current data during posting free period (that is for dates Dec 1, 2007 and after). Run full load in BW again with infopack selection set to load all data from Dec 1, 2007

Step 3: I will now have all data in InfoCube (there is no ODS in the data flow)

Step 4: Run delta init load without data transfer

Will the above steps work or do you see a problem?

Thanks very much and will definitely reward generous points for pertinent answers.

Anita S.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 13, 2008 at 03:50 AM

    Hi,

    1. After initialization, a pointer is set on the R3 side saying for this data source, any data posted after this time stamp will be considered as

    delta i.e only the changed values or newly created values should be sent. So the records posted/created after delta initialisation will

    start moving into delta queue.

    During setup table delata queue will not be used. Entry in the delta queue for particular data source is created only after initialisation.

    2 The system cannot understand the meaning of / / . after the dates are entered the system checks the consistency and consistency fails with blank dates. So u should enter the date with date format but not blank. You can specify any date for e.g 01/01/1800 which can never occur as your limit.

    3. I would say the following

    a. Run the setup tables with selection dates 01/01/1800 to

    1/01/2007 and make sure no data is posted.

    b. run the info pack with repair full request.

    c.Run init delta without data transfer

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 13, 2008 at 03:47 AM

    Hi,

    1. After initialization, a pointer is set on the R3 side saying for this data source, any data posted after this time stamp will be considered as

    delta i.e only the changed values or newly created values should be sent. So the records posted/created after delta initialisation will

    start moving into delta queue.

    During setup table delata queue will not be used. Entry in the delta queue for particular data source is created only after initialisation.

    2 The system cannot understand the meaning of / / . after the dates are entered the system checks the consistency and consistency fails with blank dates. So u should enter the date with date format but not blank. You can specify any date for e.g 01/01/1800 which can never occur as your limit.

    3. I would say the following

    a. Run the setup tables with selection dates 01/01/1800 to

    1/01/2007.

    b. run the info pack with repair full request

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.