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

Any FM/Report or BAPI to delete ODS-Cube data

Hi,

I've to delete data content from lot of ODSs and Cubes, so was wondering whether there exist any standard FM/Report or BAPI for this.

I could find one FM - RSAU_INFOCUBE_CONTENT_DELETE which I guess would work for both, ODS and Cube. And if yes then would have to write a report which would call this FM, and then I can pass the list of ODSs and Cubes.

Is there any simple or alternate method to achieve this ? Please let me know.

Regards,

Vikrant.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 10:40 AM

    Hi Vikrant,

    you can also use transaction delete_facts for deleting the data of cubes and ods objects. Additionally the transaction generates coding for these actions if you want.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 10:44 AM

    vikrant,

    see a program for delete your ods.

    &----


    *& Report ZZZZZ *

    *& *

    &----


    *& *

    *& *

    &----


    REPORT ZZZZZ .

    • Programma ********************

    DATA O_ODS TYPE REF to CL_RSD_DTA.

    DATA: O_NAME(30).

    SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE Text-001.

    SELECT-OPTIONS SO_ODS FOR O_NAME NO INTERVALS.

    SELECTION-SCREEN END OF BLOCK B1.

    SELECTION-SCREEN BEGIN OF BLOCK B2 WITH FRAME TITLE Text-002.

    • PARAMETERS: O_NAME(30) TYPE C OBLIGATORY.

    PARAMETERS: P_EVENT LIKE TBTCSTRT-EVENTID,

    P_PARAM LIKE TBTCSTRT-EVENTPARM.

    SELECTION-SCREEN END OF BLOCK B2.

    LOOP AT SO_ODS.

    O_NAME = SO_ODS-LOW.

    CREATE OBJECT O_ODS

    EXPORTING i_INFOPROV = O_NAME.

    CALL METHOD O_ODS->IF_RSD_DTA~DTA_GET_INFO

    EXPORTING I_OBJVERS = 'A'.

    CALL METHOD O_ODS->IF_RSD_DTA~DELETE_DATA

    EXPORTING I_WITH_DIALOG = ' '

    I_INCL_DIME = ' '.

    CLEAR O_ODS.

    WRITE AT /5 O_NAME.

    ENDLOOP.

    IF NOT P_EVENT IS INITIAL.

    CALL FUNCTION 'RSSM_EVENT_RAISE'

    EXPORTING

    I_EVENTID = P_EVENT

    I_EVENTPARM = P_PARAM.

    ENDIF.

    WRITE: AT /5 P_EVENT,

    40 P_PARAM.

    HOPE THIS HELP.

    ALESSANDRO

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 09, 2005 at 03:11 PM

    Thanks Siggi, Alassandro.

    Alassandro, your code could be helpful (although I need to try it, I do not have developer access right now..), but does your code work for both, ODS and Cubes ? If yes, then does it delete data from cube aggregates also ?

    I guess it works only for ODS...

    Regards,

    Vikrant.

    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.