Selective Deletion of Change log

[Former Member]

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

[former_member210321]

Hi,

When the data is activating in DSO, it always compares the new data(activation) with the active data(Active table).

Based on this you will have data in change log table(type of record will be indicated by 0RECORDMODE in change log table).

No issues if you clear the change log tables and it won't effect the Delta.

Regards,

[john_hawk]

Hi Naveen,

If the bad data has been selectively deleted from both the DSO and the InfoCube at the same time, you are OK. The change log would only be reposted again if the InfoCube request were deleted and resent.

Please don't forget to record your final solution and to mark the question as answered.

Good luck,

John Hawk

[Former Member]

Hi Naveen,

As per my knowlegde if you already have done a selective deletion and data is no longer present in Active table, I'm not sure about your statement:

"Without deleting Change log if I reload the corrected data, I will get the wrong results"

I never had this issue before. I would think corrected data should load correctly with a FULL Load and no issue should exists.

Have you tried load corrected data ? Can you kindly explain this ?

Best Regards.