i am planning to insert a DSO in the flow of datasource 2lis_02_scl, so instead of DS->Cube i will have DS->DSO->Cube.
my question is : is it possible to have an overwrite DSO for 2lis_02_scl as the business content DSO 0PUR_DS03 delivred by SAP is updated in addition mode for some KFs.
if you have already done it in a production mode, please advise.
2LIS_02_SCL delivers delta in ABR format.
So technically, if you want to use DSO in overwrite mode, you need to pick only after images using 0RECORDMODE.
So the answer to your question would be yes technically.
But if you refer to documentation for this datasource SAP recommeds additive mode for some key figures. Go through the documentation for more pointers.
Look at following thread as well
just check following things
You can load DSO and check whether your data matches what is there in cube in production..
this will be perfect test to confirm on design..
Thanks and regards