Skip to Content
0
Former Member
Jul 20, 2016 at 01:55 PM

Selective Deletion of Change log

1725 Views

Hi Friends,

We have been loading data to a DSO (Standard) and then to the cube.

data load to the DSO is a delta from another DSO (Write Optimised). The issue I have is i have loaded multiple requestes to the Standard DSO and then to the cube. Now there is an issue with data for one of the request, so I have to deleted the request from the cube so data is removed for that request.And now I have to selectively delete data from the DSO because other data loads happened after the request which has an issue. Hence If i have to delete the request which has this problem, then I have to delete all the other requests which were loaded after this one and also from the cube.

So I have deleted the data from DSO selectively from Active table, however Change log entries still remain. Without deleting Change log if I reload the corrected data, I will get the wrong results. So I tried the option in the DSO administration Delete Change Log, but here I can delete change log either by number of requests or older than a specific date. This means if i choose either one of the options then there will be an issue if a delta comes thru for data which was loaded with other request. My question is is there a way I can delete Change log data for a specific selection?.

I have gone thru different threads but i found only how to delete by older than a specific date.

Your help is appreciated. Thanks you in Advance.

Regards

Naveen