Hi,
I have a cube for which some of the historical data ( except current year and previous year ) has discrepancies.
We have a backup of historical data in DSO.
( Current DSO and Historical DSO are copies of each other with the current DSO holding the previous year as well as current year data where as historical DSO contains all the historical data)
Now the cube is receiving deltas from the current DSO .
If i want to restore historical data in cube, then what would be the procedure?
If i delete the historical data, and then update the same from historical DSO, how well the allignment of data would be?
There is one characteristic 0DOC_YEAR which will be useful to categorise the data yearwise
there is also one more characteristic 0DOC_DATE in the form of time characteristic
Now if i do selective deletion of historical data and update the historical DSO to the cube, which has current deltas running, does it have any effect?
Clarify me