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

What happens to records created when filling setup tables without deleting delta queue?

Hi All,

My question is in regards to deleting and reloading our Inventory cube in BI. It is a custom z cube but we are using the 2LIS_03_BF and 2LIS_03_UM extractors to load it. Because we are using AFS we also used the 2LIS_AF_STOCK_INITIALIZATION extractor as well. I don't want to delete the entire cube as you all know that the timing of loading goods movement data can be very tricky with regards to business down time and locking users out which is impossible for us at the moment. What I am thinking is deleting a subset of data from the cube (plant 1000 for example) and then doing a full load of plant 1000 from our ECC system and going through all of the plants until all have been reloaded. I figure this would cause the least amount of downtime for the business.

My only issue is deleting and filling the setup tables in ECC. Since I am not deleting the delta queues, while I delete and fill the setup tables what will happen to newly created records? will they get lost or will they sit in the queue LBWQ until I run my delta queue collection job again?

Thank you,

Anthony

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 18, 2013 at 06:00 AM

    a simple answer for your question.

    if your user is not locked at the same time when you filling the setup table, then the records will save in 2 place at the same time at data base table and and lbwq. after that when you schedule IP for full records same records will come into BW which is there in setup table and in delta which there in LBWQ so the data redundancy will occurs.

    If your data flow is data Source > PSA > DSO (With overwrite mode) > IC .

    Nothing will happen but flow is without DSo then data will aggregate at cube level.

    I hope this is clear your doubt. 😊

    Regards,

    SM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 18, 2013 at 03:17 AM

    Hi Anthony,

    "while I delete and fill the setup tables what will happen to newly created records? will they get lost or will they sit in the queue LBWQ until I run my delta queue collection job again?"

    While deleting setup tables nothing will be happen to newly creating or changed records. deletion will effect on only set up table not on base tables.

    before completion of filling setup tables if any record(specific to plant 1000) was saved that record will come into setup table as well as into delta also.

    if your delta was with selections and plant 1000 was not included then it won't come in delta loads.

    if your init without any selections then above record will comes into LBWQ and RSA7---> psa. it leads duplication.

    Do one thing, without locks, better to fill setup tables at 0 business hours or on weekend. even though no guarantee. but as my guess weekend there will be no business as crismus eve and users will be off.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • before completion of filing setup tables if new record was saved which is related to plant 1000. then it will come into setup tables, but thru delta it won't come into psa. because your init with posting date selection(posting date dec 17/18/ not inluded).

      if your new record saved after the filling of setup tables then that record won't capture into setup tables also.

  • Posted on Dec 18, 2013 at 06:14 AM

    Hi Anthony,

    Its always recommended to have User Lock out for the LO Datasources.

    You may replicate the number of records if you dont lock the Users or May loose out records and this may landup in Mismatch of Data.

    Your Question

    Since I am not deleting the delta queues, while I delete and fill the setup tables what will happen to newly created records? will they get lost or will they sit in the queue LBWQ until I run my delta queue collection job again

    Full Load and Delta Load

    Assume that you have a Document number 101 for Quantity 100 which is created in 22 Nov 2013 and you are loading it through Full Load and is there in PSA and then at the same time an User is changing the Quantity to 250 which will get captured in the Delta Queue (LBWQ) and in turn will flow to RSA7 and then to PSA ,the quantity will be 250.

    Delta Load and Full Load

    And if you run delta first then do a Full Load then that will have a negetive impact on that Record.The Quantity will be 100.

    Hope this gives some understanding.

    rgds

    SVU

    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.