Error loading data into InfoCube: dupliate records
I am working on a client system and they have a problem with the data in one of their info cubes. The problem is that there are duplicates of each data record in the cube.
The data being loaded comes from 2 places... a data store and another info cube. Data coming from the data store is fine, as well as the other info cube. It's only when the data is loaded into the final info cube do we see duplicates.
We've already tried deleting and reloading the data as well as clearing out the psa but no luck. We've also debugged all of the routines and update rules but they are all working fine.
No one knows the answer... any ideas? I've run out of ideas... thanks.