Hello,
We have a DSO in which we are loading data from BODS.
All records from BODS (from "File A" & "File B" - Source for BODS) get transferred correctly in BW till PSA as it is(including duplicate records).
In the DSO, we have "DemandCalWeek" as key field(along with few other fields). As a result all the duplicate records get overwritten at DSO level. (This is the property of DSO. )
However, we are expecting that data should not get overwritten though "DemandCalWeek" is duplicate. How can we make sure the demand from both files is considered?
We proposed one Solution/Suggestion to customer:
If we want to keep all records in target without removing duplicate records then we should not keep “DemandCalWeek” as key field in respective target DSO.
However, we can't remove “Demand Cal week” from key field as it will affect reporting.
Could you please suggest what should be done in such case?
Shall we replace existing DSO by Cube?
Please suggest!
Thanks!