Question:
This is an adendum to this previous thread: /forums/viewtopic.php?t=43770&highlight=
I started a new topic as the problem I face is now a bit different and didn't want to muddle the waters of the existing topic.
Background: Two ODS's (Header, Sched. Line) are delta loaded from R/3. A further combined ODS is loaded via InfoSet DS from these ODS's. A Full Load w/ NO drop of data is done daily.
OK, First the problem with doing a FULL load of the ODS from an InfoSet as a DS on two other ODS's is that DELETES are not captured in the combined ODS. If we were dropping the data in the combined ODS daily it would not be a problem.
Now onto my quandries:
I don't want to drop the Combined ODS as it contains Legacy data (a lot) which is a one time non-changing load. But I need to get it to reflect the data properly. I have come up with several ideas and I am looking for some feedback and answers. (Or even better ideas.)
Thought 1: Can I selectively delete all R/3 data from the Combined ODS via PC? Would this affectively full delta the R/3 data to the Cube every time? Or would delta's be preserved?
Thought 2: I could get the original idea of using update rules w/ ABAP working.
Thought 3: Can I use a further ODS in between the Combined ODS and the InfoSet. That ODS would be dropped w/ a delta to the Combined ODS to preserve updates. Would this do correct delta's to the Combined ODS from the in-between ODS?
Thought 4: I could drop the Combined ODS and Cube and due a full load. This is a lot of data, but it could be done.
I would like to get a solution (optimaly 2) where deltas are running, but due to not having any timeline and pressures from my boss, I don't know that I will get that option.
Can I drop data in an ODS and still do delta's to a cube or would it not know what all changed? (Like really doing a full update to the Cube from the ODS b/c of the effective dropping of the data in the ODS each night.)
Hopefully this is not too confusing as I have not had all my coffee yet.
Thanks,
Stephen
Answer:
Nobody? Was this too much for a Friday
- Stephen
Answer:
Nobody? Was this too much for a Friday
- Stephen
Yup, my brain hurted every time I try to figure out your requirement!