Skip to Content
0
Former Member
Jun 04, 2009 at 04:26 PM

modelling question with delta changes for characteristics

102 Views

Hello All,

We have a ODS that gets updated with order number, dates and status fields. Let's say an order is created and goods delivered. The order gets a delivered status and delivered date populated. This now comes over to BW and loads our ODS and then to our InfoCube. So in the infocube we have this order with delivered status X and delivery date 6/3/2009.

Now, in SAP we can cancel this delivery to the customer. So the delivery status goes from X to blank and delivered date goes from 6/3/2009 to blank. This now comes over to BW and loads our ODS and Cube. In the cube we have 2 records. 1 showing these fields populated and the other showing them blank. If a user runs a query that has created date they get 2 records, not good.

This load from ODS to cube is a delta. If we run full load from ODS to cube we get all data correctly because the ODS is basically a current snapshot. Why does not the delta to the cube from the ODS somehow take care of this previous record and not show in the query? We thought this is how the delta mechanism works. We see it working correctly for key figure changes, but not for characteristics. Meaning if delivered qty was 5 and existed in cube and then the 5 changed to a 10 in SAP, the eventual updates to the cube show only 10, not 15, for example.

How do you handle the delta update for characteristics?

Thanks!