Question:
I am really stumped on a delta loading issue. We are loading Actuals using datasources 0CO_OM_CCA_9, 0CO_OM_OPA_6 and 0CO_OM_WBS_6 to cube 0COOM_C02. After initializing the delta with selection criteria FISCPER = 002/2007 to 012/9999, CURTYPE = 10, KOKRS = ‘CITY’, the daily deltas are missing line items in the PSA.
Using the same datasources and selections in Full load mode all the items are picked up. We are on 3.5 with the latest patch level. I suspect a time stamp issue but I don’t know how to prove that.
I can provide more details. What should I look for?
Al B.
Answer:
I am really stumped on a delta loading issue. We are loading Actuals using datasources 0CO_OM_CCA_9, 0CO_OM_OPA_6 and 0CO_OM_WBS_6 to cube 0COOM_C02. After initializing the delta with selection criteria FISCPER = 002/2007 to 012/9999, CURTYPE = 10, KOKRS = ‘CITY’, the daily deltas are missing line items in the PSA.
Using the same datasources and selections in Full load mode all the items are picked up. We are on 3.5 with the latest patch level. I suspect a time stamp issue but I don’t know how to prove that.
I can provide more details. What should I look for?
Al B.
Hi ,
We too had the same problems, as a work around we did full loads on fiscal period (current and previous).
Good luck.
Answer:
No insult to bsr intended but that is unexceptable. For us the deltas have worked fine for a few years now.
What has changed is we added an ODS to pick up all the line item detail including document number and dates that are available in the standard datasources.
We have also appended the structures to pick up additional fields using the customer exit. I have since commented out the code in the include and hid the fields to test if that was the cause of our delta issue but it still exists.
I've searched OSS notes and here, SDN. I guess the next thing to try is reinstalling Buisness Content. Any body have any ideas?
Answer:
Reinstalling the R/3 content datasource, replicating in BW and reint delta from 002.2007 to 012.9999 then delta load did not get any records this time.
Any help would be greatly appreciated. Does this warrent opening an OSS? Am I doing something wrong here?
Answer:
Bump.
Any ideas on what to check?