How to delete the compressed Request ID in the info cube...>?

[Former Member]

Hi BW Gurus,

one of the info package will upload the request in to three data targets and failed due to error with duplicate records. I am able to delete the bad request in two data targets and facing problem with one data target due to the request is available in green and got compressed.

The reasons why i am unable to delete the request in that data target is it is already got compressed and rolledup.

I tried with selective deletion based on same request ID i have done that successfully but the request still presents in the data target. I have checked in listcube and found no data for the request id.

now i have one more question like the request has bring down to status not ok in the monitor and done selective deletion will it be a problem on the data missing please advise me if any data missing will occur for the particular data target.

can any one help on this. Thanks in Advance.

Venkat.

[Former Member]

Hi Venkat

You have one way to delete the compressed request

But this is possible only if u have the request in PSA

If the request is in PSA, do reverse posting

This will nullify the particular bad request by changing the press sign into - and - sign into + for all the records went in the cube for that particular request

Regards

N Ganesh

[former_member188325]

Hi,

As you said Data has already has been rooled up into aggregates so you have to de activate the aggregates to be able to delete data.Since request is compressed,you have to delete data using Selective deletion.I am not sure you can use request id to delete the request.

Murali.

[Former Member]

Hi Murali,

I have deactivate the aggregates and tried for deleting the request but it is throughing following message Request ID 0000420421 is aggregated, compressed or scheduled. Yes we can selectively delete the request id.

Now my issue is i need to erradicate the above request from the info cube.

please suggest me if any possible reasons to overcome on this.

Thanks

Ganni

[former_member188325]

Hi,

you can not delete the request anymore if it is compressed.Instead you can delete the records selectively from cube.please search in forum with delete compressed request...you will find lots of threads.you may find some useful info related to your issue.