Duplicate records problem in cube
We have problem where we have duplicate records in an infocube and I am wondering how to repair this aside from a reload. This problem is a result of a failed dataload from the source infocube. A repeat delta was done at which time the system loaded the delta as well as the previous day's records again. Since the target is a cube the amounts are doubled for those particular records that have now been loaded twice. Unfortunately the cube has been compressed and we cant back out any packages. I am wondering what would happen if i did a Repair Full Request for the affected periods. Would that increase the amounts again or does the system somehow check the existing balances and adjust accordingly. Would i get the proper ending balances? Are there any other solutions?
You can get the solution through indirect workaround like below:
1)Find duplicated records with document number, posting data, creation date, like.
2)Delete above duplicated records from cube with selective deletion option.
3)To load with above selection document no., posting data, creation date.