Problem with Bad Data in ODS we need to remove.
Using BW 3.5 we are extracting data from Oracle tables and loading the data in ODS' and Info Cubes.
I discovered that in our processing last week we missing some rows of some tables, but not others and I need to remove the data loaded last week so we can reprocess last weeks data again.
We have 2 oracle tables: POLICY and COVERAGE
Using DB Connect we first bring in POLICY and Full load to a ODS (ZPOLICY).
Second using DB Connect we bring in COVERAGE with a Full load to a ODS (ZCOVERAGE), only in these Update rules we have routines that read some information from ZPOLICY.
What happened is that for a unknown reason, the read from POLICY only read about 1/2 the rows, but all of the COVERAGE data was read in. This resulted in some of the ZCOVERAGE ODS fields missing the data read from ZPOLICY.
The data in the ZPOLICY and ZCOVERAGE was then used to Delta update a third ODS Policy Coverage (ZPOLCOV).
What would be the best way to back out of the bad data from all 3 ODS'??
My method was to delete the requests from the ODS', however I must have done something wrong, since I am now receiving:
"Last delta incorrect. A repeat must be requested. This is not possible" messages.
I believe I removed the requests first from ZPOLICY and ZCOVERAGE, before ZPOLCOV.
I was able to bring the data into ZPOLICY and ZCOVERAGE without a problem, however I am unable to get ZPOLCOV to process.
I keep receive messages complaining about today's requests.