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

LO Extractor: user to update in ECC during setup table runtime

Dear all

Is it true that for Queued Delta, user is allow to update during setup table runtime (filling) ?

Actually I refer to SAP Note: 602260 - Procedure for restructuring data for BW (point #8).

Won't it create double because the updated data would be written both in Extraction Queue and Setup table?

Thanks

Halomoan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 28, 2011 at 04:43 AM

    Hi,

    I don't think you could do that. While filling Setup tables, we need to take down time and lock the Users/data postings etc..

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/90fddfcd-a956-2d10-19be-8f7bdd699a05

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80f4c455-1dc2-2c10-f187-d264838f21b5

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f0709b9f-acbc-2c10-7a95-ab0ee18b921c

    Regards,

    Suman

    Edited by: Jason Lax on Dec 28, 2011 2:18 PM (Updated URLs to correct format)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 28, 2011 at 05:26 AM

    Hi,

    Actually there are chances of data duplication, if you read point no 3 and 4 from above note you will get the answer.

    There are many alternatives for e.g. you can upload the data to DSO and then your delta will be managed from there.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thank you for the replies but there is still a doubt.

      Let simulate the condition like Rahul did.

      1. Lock the users

      2. Set up the datasource in Queued delta mode <= here Extraction Queue created and V1 will start to capture delta if there is change.

      3. Load the setup table + unlock users. <= according to the Notes, during setup table runtime, we already can release the user lock.

      4. Carry out init with data transfer

      5. Run the V3 job.

      The problem is on between point 3 and 4, Extraction Queue could have same data in the Setup table and eventually will be transfered to BW via Delta queue.

      Is it true and how should we do?

      Thanks

      Halomoan

  • Posted on Dec 29, 2011 at 04:40 AM

    Hi,

    You can actually unlock users while you are loading data to BW...DATA in BW is extracted from set up table and not from any other queue say LBWQ or RSA7 at this point of time of data loading..

    You can minimise downtime by just loading the set up table say for current 3 periods or as per say created on or posting date..

    Thanks and regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      With "Delta queued" and "unserialized V3 update", documents can already be edited again during the runtime of the initialization request.

      With Queued or Unserialized updates, you would only need locking time till setup tables are filled. Point 8 from the note says that users could be allowed to post once setup tables and filled and even when initialization request from BW is running.

      For direct delta users could be unlocked only after both activities - filling the setup tables and completion of the init request from BW, as there will not be intermediate queues like extraction queue/update queue in this case.

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.