尤尼佳33_DELTAUPDATEINRULES.docVIP

Delta Update in the Update Rules Even if only the delta update for InfoSource S261 are described in this paper, this documentation applies to the Update Rules S260/LREBO01 and S261/LREBO01 because the technique is the same. I. LREBO01 1. Background When loading data from an R/3 system the Business Content Extractors perform a Delta Update. For non R/3 systems, things are more complicated as not all of these systems are able to deliver delta records. The following example will illustrate the problem: Before: after: Delivery n° 123456 ( Delivery n° 123456 Delivery position 0010 ( Delivery position 0010 Change date ( Change date Quantity delivered 100,00 ( Quantity delivered 120,00 In the above mentioned case, the R/3 extractors would deliver a line with the change datean a quantity delivered of 20,000. A flat file instead will just deliver the absolute value of 120,00. The question is now: Where can the difference between old quantity and new quantity be calculated ? 2. Technical Overview In the scenario implemented at Roche Diagnostics the difference between the old and the new value will be calculated in the update rules. When loading a line from the communication structure (1) to the cube, the initial line (2) will be read from the cube (delivery number and delivery position as unique keys). As not only key figures can change but also characteristics, it is not possible to calculate a simple delta (difference between initial and new keyfigure values). There has to be a complete reverse posting (3) for the initial line before loading the new line (1) to the cube. In the case that all characteristics of the initial and the new line are the same, BW will write only on record into the cube. 123456 0010 -100,00 123456 0010 20,00 123456 0010 120,00 Conclusively, two alternative cases exist: When having changes on characteristics and key figure level, two lines wil