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

[former_member206066]

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

[former_member206066]

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

[lucdealethea]

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

[former_member206066]

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