Let me summarize my scenario.
I am working on COPA planning solution and we have a
Budget input report - where users input data
Budget retraction cube - where input data is stored
Budget status cube - shows plan data value after COPA retraction
After planning, we load data to budget retraction cube. Then I go to R/3 and use KELR TCODE to retract the data to COPA table. This creates a new delta record then I load a delta chain to update first level DSO and then to the Budget status cube. so I am expected to see same values in all places.
Budget Input report, Budget retraction cube, COPA table and Budget status cube report.
So far for some materials, the budget status report is showing incorrect values and also incorrect in first level DSO.
I have tried to do selective deletion and reload full load but some document numbers are not coming through. The loading to the DSO is 1:1 mapping so I am trying to figure out why can't I extract full records from COPA table.
any idea how this can be resolved and what could be the reason.