Skip to Content

Need to Delete last Request From Cube and DSO (by ABAP program or any other ways)

Hello Experts,

I need to delete last Request From DSO and Cube .

The flow is like ,it does full load from DSO1 to DSO2 and Delta load from DSO2 to Cube1.

I need to delete last Request From DSO2 and Cube1 automatically.

I could not get any other way to delete it by any BW procedure, so tried to write a ABAP program.

The logic is like :

It will take max( REQUID ) from the table RSBKREQUEST where Target = Cube1

Then ,Update table RSBKREQUEST set USTATE and TSTATE = '4'.

Done same for DSO2.

This program is deleting the last request from the manager screen of the DSO2 and Cube1 .

But the data is staying in the content of Cube1 and DSO2(active table and change log table).

Do I need to delete data from from DSO's active table and change log table , and need to delete data from Dimension table and fact table of cube.How can I do it??

Please suggest.

can anyone suggest any other way to delete last request??

Thanks,

Ipsita

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 12 at 02:54 PM

    Hi Ipsita,
    there is a special process chain type "delete overlapping requests" from infoprovider and you might choose the infopackage related to the DSO then choose delete options based on the request date.

    I think that might fit into your needs.

    Cheers,

    Luc

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Luc,

      I think overlapping request step only can be used for Full loading to Cube.

      I think it can not be used for DTP requests of DSO or Delta loading of Cube(The flow is in 7.x version and we can not change the DTP settings).

      Thanks,

      Ipsita

  • Jan 15 at 08:05 AM

    Hello Experts,

    I have got some FM: "RSDD_INFO_REQUID_DELETE' ,"RSDD_INFO_REQUID_GET" , "RSSM_PROCESS_REQUDEL_CUBE" and "RSSM_DELETE_REQUEST".

    The FM "RSDD_INFO_REQUID_DELETE" is not working.

    But the FM "RSSM_DELETE_REQUEST" is working

    can anyone help me , what is the difference between these 2 FM "RSDD_INFO_REQUID_DELETE" and "RSSM_DELETE_REQUEST"

    Thanks,

    Ipsita

    Add comment
    10|10000 characters needed characters exceeded