can we delete particular request from ODS

[Former Member]

Hi All,

Can't we delete particular request from ODS?

there are dozen of successful requests in ODS, when i deleted one successful request from the middle, all the subsequent requests lost the tick which indicates they are updated to cube. Is there any way that i can undo this one?

can we do selective request(successful) deletion from ODS?

Thanks in advance.

Robyn.

[Former Member]

Hi Samara,

what i was trying to do is re-arranging the requests according to chronological order, which are not in. imagine the scenario

ODS requests cube request

5 -> E

4 -> D

2 -> B

3 -> C

1 -> A

what iam trying to do is put them in sequence

ODS request cube request

5 E

4 D

3 C

2 B

1 A

If i delete 3rd ODS request put it over 2 it won't accept as the request number is lesser than that of 2nd request.

can we reconstruct any request from reconstruction tab or just the latest request?

How does this effect the data which is already updated to cube from ODS?

Regards,

Robyn.

Message was edited by:

Robyn Hoggard

Message was edited by:

Robyn Hoggard

[Former Member]

Hi Robyn,

It is not possible to delete a particular request from the ODS.

This can be compared with a stack of boxes which stand one above one and you cant remove the middle ones with out disturbing the ones lying on the top.

An alternate other than selective deletion is to delete all the requests loaded after the request which you actually want to delete along with it and then go for reconstruction and load all the deleted requests except for the one you do not want.

Hope this helps you,

regards.

[Former Member]

Hi Robyn,

Its not possible to delete a particular request from an ODS.What i can suggest you is to go for "Selective Data Deletion".Which can resolve your problem.

hope it helps,

regards,

Parth.