Unable to delete the request from ODS

[Former Member]

Hi All,

I have loaded a request to ODS from flat file and the load got success, the request is activated and is available for reporting. Now the problem is i want to delete the request, but the request is not deleting.

I tried to delete the request by going in to the cube manage and changed the QM status and the technical status to red and delete, but it is not deleted.

Thanks in advance for your reply

[former_member619464]

Hi Prem,

If the ods has datamart status & has been used to load data to a cube, then u cant delete the ods request. In this case, first, change the QM status of the request in the cube to red (delete) & then it wud be possible to go with the deletion of ods request.

Also check this thread as well

Regards,

R.Ravi

[Former Member]

Hi,

Is this request updated into info cube? check weather you have authorization to delete a request. execute delete operation and run Tcode SU53 and see is it successful or not.

Regards

Sankar

[Former Member]

Hi,

Check in SM12 , whether any lock entry is present by putting * for username.

if any lockentry is present , then delete it and then delete the request from the ODS.