Data deletion

[former_member188760]

Hi Experts,

I want to delete(selectively) the data for the fiscal year peroid 2011-10 in the infocube and DSO and reload the data from source system for the same period again.

Data is loading from R3-->DSO(delta)->Infocube(Delta).(Network cube)..I checked the data count in RSA3 and DSO are same ie 20000 for confirmation.

My question,is if i delete data selectively from DSO,does the data also delte from Changelog table also?

If not, after i reload the data from R3 to DSO-->cube.(Iam doing here with Full repair)...How the data will update from ODS to Cube.(if the old data in Change log table remains, then this will be added to new data whcih we relaoded).

Please advise.

[former_member182343]

Here i am pointing about Delete CLT data.

We can do it - But it based on two dates - 1. before date

2.After date.

Better test this method and do.

Manage on DSO - Environment tab - select Delete CLT data and find options.

Can I know for which datasource you are doing - what is the rule type of KF.

Regards,

rvc

[Former Member]

- Changelog will not be deleted, only the active table.

-Now about the delta (I suppose you use a DTP): first you have to remove the wrong data from the infocube with a sel. del also.  Then run a delta DTP to your cube (after the DSO is loaded).

In the change log all the new records will be marked as new.  And because there is no trace left of the old situation, it will work fine.  But only if you are able to remove all of the old, wrong records in the DSO and cube.