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

Deleting the data from Cube automaticaly

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 03:18 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 03:21 PM

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

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2007 at 03:39 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.