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

Accidental deletion of INIT selection conditions on 2LIS_02_SGR Infopackage

Hi BI experts,

We have got some difficult situation due to accidental deletion of Init and selection conditions on 2LIS_02_SGR datasource Infopackage..

We have been doing Init W/o datatransfer for range of periods and doing Repair full request for the respective periods so deltas have been getting accumulated in source system so far for the last 2 or 3 weeks

but unfortunately some one deleted Init selection conditions from Infopackage so due to that all respective delta que(RSA7 and SMQ1) has been empty so now all the delta changes for those periods during this 2 or 3 weeks lost ...

So as per my knowledge we can not really recover and need to do again setting up of tables for reinit and proceed BUT as user group is not willing to stop transactions for such a long time again...Trying to know from community whether can we have any other best alternative to handle this situation..

I really appreciate if some one gives a best advise on this ..

Thanks & Regards,

BRK

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 Feb 23, 2009 at 06:56 PM

    Hi,

    If you are currently loading into an ODS with the key figures set to overwrite, you can reload the data and it will overwrite the key figure data (rather than add it like a cube).

    If you are not currently loading into an ODS, you can create an ODS (key figures set to overwrite), load the ODS from your cube's datamart (update rules set to default/no transformations), then reload the last 2-3 weeks into the ODS. Check out the data in your ODS and make sure the new data and the old data (from the cube) matches R/3 and the cube (for the old data). Once everything is set, load your ODS data into the cube. You'll also need to reinit the datasource.

    Since I am not familiar with your update rules or architecture, please understand that any master data lookups in your update rules may change that data (for example, if you are loading material type as an attribute of material and that material's type has changed, you will load the new type and not the old one).

    So, it can be done without a reload from R/3//ECC, however you need to be careful and make sure whatever data you move or reload doesn't change.

    Good Luck,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi BRK,

      That is a great overview of what you are trying to accomplish in R/3//ECC. Just a few more questions:

      1.) Is the business global? Meaning are they 24/7 with no real holiday for the entire company? What I am getting at is if there is any downtime ... even an hour, that you might be able to get the system with little to no user activity? Is it possible to extend the maintenance window on your maintenance weekend?

      2.) How long does it take to fill the setup table for 1 month vs. 3 months vs. 6 months vs. 12 months vs. 2 years? There could be a significant difference in those times. For instance, I have seen situations where 12mos. will take 10 hours to load while 3 mos. takes 30 minutes .... 4 x 30 = 2hrs for that year vs. 10hrs.

      Now on the backend .... what does your architecture look like? Are you loading into a cube or an ODS for each of the 3 datasources? If you are loading into an ODS and all of the key figures are set to overwrite, then your duplicate data will overwrite. Which is fine. You just need to finalize loading the ODS before you send the data further on to another ODS or Cube.

      Now, if you are loading directly to a cube or your ODS has additive key figures, it gets complicated. You cannot load duplicates. If you have a quiet day (see 1 above), then you can load the data into the setup tables, initialize and bring your delta in also, then in the PSA, delete out your duplicates. You will know what your duplicates are because they will be in that first delta ... not all, but some. So, just go through the delta records and identify which records are already in the initialization.

      Brian

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 10:27 AM

    Hi, BRK.

    It might be possible to do de delta inits in small packages e.g selection of months, year.

    In that case the amount of records is not very big and the system can still be running.

    After that change the month,year and so on.

    The only thing that you should do is change for the original delta load the selection fields en fill them in accoording to the initialisation.

    If done it with CO-PA and that was been very usefull.

    Good luck,

    Hans

    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.