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

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member]

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.

[Former Member]

Vikrant

the program is valid also for the cubes and if you have some aggregates, they are deactivate e reactivate deleting all the data.

alessandro

[Former Member]

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