Need Help Understanding deltas
We have recently had to reload our Material Movements Cube. Everything worked out well until we ran the nightly delta updates. The delta INIT for movements for example had 22,000+ records..... all the data was confirmed to be PERFECT.... then we immediately ran a delta update and there were zero records which was PERFECT.... then came the second night and the second set of delta updates and there were nearly 22,000 records and the data was definitely wrong.
When doing analysis on the delta INIT in the PSA I can see all the posting dates are from 4/3-4/5 which was our selection criteria upon setting up. When doing analysis on our delta UPDATES in the PSA I can clearly see it has documents with posting dates from 3/20-4/5... not sure why it would pick up those old dates. Also when the delta update was running we were concurrently running a FULL UPDATE of records from prior to 4/3 to capture the historical data. Our understanding is that this should not have had any affect on the delta updates so we are certainly puzzled as to why the deltas are wrong.
Any clues or suggestions?