Deleting the data from Cube automaticaly

[Former Member]

Hi All,

I want to delete the data from Cube with the selections i am giving in the infopackage. is it possible, i know the process of selective deletion but its not going to work for me, since the infopackage varibles are automated.

For ex: i am the having data in the cube like this year 2005-2006 , vtype 10 in one request ID of the cube, if i want to load year 2006, vtype 10, again into cube, so i need to delete the 2006 vytpe 10, so i cannot delete the entire req id since it contains 2005 also.

so how can i selective delete this set of data automatically.

I have seen the FM RSDRD_SEL_DELETION, can we use this in the Infopackage selective deletion routine.? or it can be used in anyother place can anyone please provide the code that i have to use. This is very important for me.

Thanks in Advance

Vj

[Former Member]

Selective delete will not delete the request, rather a subset of the data in the cube. As I said before, call the FM in a program and schedule the program in a process chain.

Ravi Thothadri

[Former Member]

Calling the FM in the process chains is fine but is there any way you can do this in Infopackage level.

[Former Member]

Call that FM in a program and run it in the process chain either before or after the data load.

Ravi Thothadri

[Former Member]

Thanks ravi and Kishore,

If i do selective deletion in the Infopackage routine then it will delete the complete request Id, which is not i wanted, based on the entires in the infopackage it should only delete the data in the cube not request. I dont want to use Process chains as per the managment, Can i use the FM in the Infopackage routines, If yes how can i use it, any sample routine can be helpful.

Thanks

Vj

[Former Member]

Hi,

Yes you have to go for selective deletion only... In the selection deletion you have to give the year, vtype & the request id as parameters and delete the data.

In your case it is year 2006, vtype 10 & request id whatever is generated... I guess it should work fine...

Go thru this links, u might get an idea:

http://help.sap.com/saphelp_nw70/helpdata/en/80/1a659be07211d2acb80000e829fbfe/content.htm

http://help.sap.com/saphelp_nw70/helpdata/en/d4/aa6437469e4f0ae10000009b38f8cf/frameset.htm

Regards,

Kishore

Message was edited by:

Kishore Sivakumar