What's the stand Purchasing ODS corresponding to cube 0PUR_C01?
Our current design is that we load Purchasing Item data from R3 to BW standard InfoCube 0PUR_C01 and then use this standard cube as data mart to feed data to different cubes of different clients. Then later we find there could be shortcomings for this design since if some record is cancelled/deleted on R3, then one canceled/deleted record on R3 will become two records on BW which could confuse customers when they run queries, especially if a record gets changed, then the Delta mechanism would send more records to BW for one single modified record on R3 that confuse customers when they run queries. Therefore we consider if we use an ODS as 1st level to load data from R3, then since ODS has the feature of "Overwrite" which could bring only one record over to BW for one single canceled/deleted/modified record from R3.
We are not sure if we use ODS to collect data from R3 and then use this ODS as data mart to feed data to different client cubes would meet our needs stated above to not to confuse our customers when they run queries. Hope experts here give us suggestions! If you think the idea would work, then could you let us know how to locate the standard purchasing item ODS which corresponds to the standard purchasing item cube 0PUR_C01 which we are currently using in Business Content?