Question:
Hello All,
I have a task to delete the previous load(request ids into Infocube) for every new data upload performed.
How do I do that. Please Help.
Prasad
Answer:
Find your infopackage for the cube load. Go to the data targets tab and press the button in the column "Automatic loading of Similar/Identical Requests from the infocube". You will find the available options there.
--Andreas
Answer:
Hello All,
I have a task to delete the previous load(request ids into Infocube) for every new data upload performed.
How do I do that. Please Help.
Prasad
default update mode is addition for infocube as compared to
ods. have u tried event management for this.
me also would await advises on this issue.
Answer:
Hello all,
thanks for the inputs.. i have gone thru the options available in the Infopackage screen.. but neone..has done by using a routine?..please help with a sample code .. am unable to find to find it...
prasad
Answer:
The routine uses the l_t_request_to_delete table to keep track of requests to delete. You can look at its structure by doubleclicking on "rsreqdelstruc" in the table declaration (or go to tx SE11). You will have to make sure this table contains the requests you want to delete.
Debug this routine (or wait for someone in the forum to tell you) to see if the table contains the requests in your data target, in that case you need to delete the ones you don't want to delete in the loop that is predefined. If not I think you will have to find the requests you want to delete in the table RSREQDONE and insert the relevant ones into l_t_request_to_delete. Is this the right table, anyone?
--Andreas
Answer:
You can access RSREQDONE with the PSA name (field ODSNAME, ODS was previously the name for PSA). However, do you need to use a routine? What is the criteria you want to delete requests for? All previous requests? The last one from the sam infosource?
--Andreas
Answer:
Hello Andreas,
thanks for ur inputs, i would check out with table mentioned.
I am working on Infocube and not ODS. I tried with the existing radio button options in the tab - data targets of infopackage screen.
but I have to write the routine instead of going by options.
Could you help me giving a sample code, how to delete the the xisting requests, do i utilize the table u mentioned and check for my infosources and delete the respective one?...how actually to do this...
please help...
prasad.
Answer:
reference taken from sapfans.com only
(Location: Belgium Posted: Fri Jul 30, 2004 9:40 am Post subject: )
1. execute two infopackages one after the other: no problem
2. delete previous requests: also no problem. There is a service called 'Delete overlapping requests from infocube' that deletes the previous requests of the infopackage. You have to create a variant for that containing the infopackages.
In those infopackages however you should also enter the deletion criteria, in you case '...in last 7 days'.
Answer:
You say you need to use a routine, are you sure about this? If you just want to delete the previous request or all previous request, that can be done with the options.
However if you want to use the routine you first need to find out if l_t_request_to_delete contains the requests in your target or not (I don't know this). Debug. The code will be different whether this is the case or not.
I really don't have time to write your code, haven't you got anyone more experienced or someone with ABAP skills at your site? You can't be entirely dependant on a forum to solve your current and future tasks. Ask your management to staff another BW guy if you can't handle this yourself.
I haven't said anything about ODS, what I told you was that you can use the PSA name to access RSREQDONE. The relevant field is calles ODSNAME.
Good Luck!
--Andreas