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
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
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,
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
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 a comment