Wrong copa data have to be delated from Cube in production
I have some wrong delta data uploaded in Production system in last month. Now the customers business process has got changed and according to that I have made changes in update rules.
Now I want to correct the uploaded data in production system. There are around 7000 records wrongly uploaded on 31st of July. Before this month end I want to correct these records as the new data would be uploaded by this month end with updated business process.
Could any one please tell me how to do the correction I am little bit scared as I have to it in production system..
The scenario is like this.
1. Copa data comes in ODS.
2. And delta data moves from ODS to cube
The logic which I have though is:
1. I will do the selective deletion in cube for the wrong data.
2. and will do the delta upload from ODS. (But I am confused how to this)
The suggestions from all experts will be highly appreciated with reward points.
the first thing is to identify the scope of these 7'000 records.
Do they belong to one single fiscal period? To the same company code?
Try to find a characteristic for which you don't have to much data in your target cube.
Let's assume that the 7'000 records are all belonging to FISCPER 2007.007.
Check in your cube and in your ODS how many records you have with FISCPER = 2007.007.
If the amount is reasonable just selectively delete your data in your target ICube and then perform a full load from your ODS to your cube with a selection FISCPER = 2007.007 (ensure that no data is loaded in your ODS; that all request are activated in your ODS and that your new URules are active!)
This won't impact you datamart deltas; after this procedure, ensure that your data is accurate and restart your loading scenario as usual.
hope this helps....
let us know how it goes...