Skip to Content
author's profile photo Former Member
Former Member

Selective Deletion of Change log

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 04:58 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2016 at 06:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2016 at 08:34 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.