Hi Experts,
This is a two-part question.
Scenario:
I have a Standard DSO- overwrite (DSO1) at accounting line item level which pushes data to another Standard DSO-overwrite (DSO2) at Monthly Level. This Monthly DSO pushes data to a cube for Monthly Open/ Cleared accounting document snapshot.
Which means, if I have an Open item today, my cube should have that in the past month, this month and all previous month snapshots as an open item.
1. Can I do the following with standard 0FI_AR_4 deltas?
When loading data from DSO1 to DSO2 for the first time INIT load, I replicate all records that are open today and put them in ALL previous months as snapshots. From then onwards, I just build a month's snapshot at a time by pushing all deltas as Summing Before and After Image for a record that has changed. And also, pushing all previous records from Changelog that have a record mode status N.
I am just talking conceptually here and dont know of the feasibility of accomplishing the above in ABAP.
2. We could just do a full load everyday replicating Open records less than the current date into all previous months' snapshots.
For both the above possible solutions, which one is the most feasible?
Am I missing out a totally different and more practical/efficient solution?
All inputs greatly appreciated!