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

Initialisation of Delta again for a cube

Hi All,

We are loading data using delta update every day. For some reason we have to delete some deltas, take full updates and then initialise the delta again.

But when I initialise the delta again, What would happened to the data which is present in the delta queue in source system, how do I delete it to make sure that no old delta records gets pulled after new init delta is done.

I need your suggestion please.

With Regards,

Wrushali

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 26, 2006 at 05:35 AM

    highlight the datasource in rsa7.

    At the top u will notice delete button.It deletes data and metadata in the queue.

    Or use Queue menu->delete queue option.

    cheers,

    Vishvesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      got below details from help.sap.com

      -

      -


      Delete queue data

      To delete the data in a delta queue, select the delta queue and, from the context menu, choose Delete Data.

      Deleting data from the delta queue does not require the delta method to be reinitialized to write DataSource data records into the delta queue.

      Note that data that has yet to be read from the delta queue is also deleted. As a result, any existing delta update is invalidated. So, only use this function when you know what you are doing!

      Delete the queue

      You can delete the entire queue via Queue ® Delete Queue. You need to reinitialize the delta method before you can write data records for the associated DataSource into the delta queue.

      -

      -


      Link is:

      http://help.sap.com/saphelp_nw04/helpdata/en/6f/66bca6ae43744283d74f1e456ff6c0/frameset.htm

      cheers,

      Vishvesh

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2006 at 05:39 AM

    Hello Wrushali,

    the detailed steps to redo an init(assuming say a LO datasource)will be:

    1>Stop the V3 update in R/3.

    2>Delete the setup tables and you can fill the set up tables with the new selections.

    3>Delte the init flag from the infopackage for initialisation loads. in the scheduler->Initialisation of source sytems. select theinit request and delete. This will also invalidate the delta queues.

    4>Schedule a initialisation run in BW, after the set up run is successful(mentioned in step 2).

    5>Schedule the V3 in R/3. Check the first successful run and you can see the delta queues started getting populated.

    5>Schedule delta loads in BW.

    6>Delete all duplicate requests i.e the previous init and delta requests from the cube which were existing prior to the latest initialisation run in step 4.

    Hope it helps..

    thanks,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      The information posted is very helpful.

      I have one doubt on this :

      As mentioned point 4 & 5 , the doubt is should the V3 scheduling in R/3 be done after Delta Initialization request is activated or simultaneously V3 scheduling can be done without wating for request is activated in cube .

      Please guide.

      Abhishek

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2006 at 05:33 AM

    Hi,

    If you want to do a new Init again, go to the respective Infopackage screen ->SCHEDULER->initialization of source system->This will give you the init pointer. just select that and delete it.

    After this you can do an init again.

    Thanks,

    Raj

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2006 at 05:58 AM

    Hi all,

    Thanks a lot. It has solved my problem and I have already thanked by rewarding points.

    Just one doubt I wanted to get cleared. We are using Direct Delta method for this particular datasource, will it create any problem while using the suggested methods.

    Please advice.

    With Warm Regard,

    Wrush

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Wrushali,

      it should not create any problems. but the direct delta schedule needs to be stopped during this re-init.

      it can be resheduled after the new init to pull on deltas thereon..

      Hope it helps..

      thanks,

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2006 at 07:06 AM

    Hi Aby,

    Thanks a lot.

    With regards,

    Wrush

    Add comment
    10|10000 characters needed characters exceeded