Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Duplicate records problem in cube

Hello,

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?

Regards,

TMS

Former Member
Former Member replied

Hi

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.

Cheers,

Sree

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question