Initialisation of Delta again for a cube

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

Hi Aby,

Thanks a lot.

With regards,

Wrush

[Former Member]

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

[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,

[Former Member]

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,

[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

[Former Member]

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