Full load doesn't extract all records.

[bhat_vaidya2]

Hi,

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.

- Bhat

[former_member184884 · Accepted solution]

Hi,

what an coincidence i mean recently worked on same issue related to mismatches in retraction data however there is slight changes in our process, but issue is almost same!!

Below are the possibilities which leads to mismatch in the data.

• please check routines at different level(transformation) mainly start & end routine its biggest culprit which excludes the records based on the logic in my case start routine logic filtered the records while updating data from one dso to other.

• make list of materials/products which are having issue check with concern functional(CO) team in some cases this materials might have delisted in ECC.

there might be some other reason as well i was just sharing my views.

Hope it helps you in some extent!!!

Regards,

Harish

[bhat_vaidya2 · Accepted solution]

Hi,

I have now identified the rootcause. The reason was DSO has document number as key field and in CE2* table we have a material / plant combination that has 2 document numbers and only one line is being extracted.

I don't want to remodel by deleting the data because the DSO has about 6 million records and feeds data to several cubes.

Instead of remodelling, I am thinking of summing the keyfigure by document number in the ENDROUTINE. Has anyone tried this method before.

Thanks,

Bhat

[Former Member]

Dear

it may exceeds the limit make 2 data loads then it will take all records

Regards