Skip to Content

After publishing my The Diary of a BW 7.3 Ramp-Up project (Part 4), I was asked about the ‘force delta’ process which was recommended by SAP. This process isn’t a new feature at all, it is just another way of getting a delta from a DSO. One should always implement this process in case there are two or more DataSources which should be combined into one Object
using a different key. All datasources have their own delta and all data has to be enhanced by data from the other DataSources. In the target object the most actual data has to be stored.
Here an example:

DataSource 1:
Field A (Key)
Field B
Field C
Field D
Field E

DataSource 2:
Field B (Key)
Field C
Field F
Field G
Field H
 
Target-DSO or Characteristic:
Field C (Key)
Field A
Field B
Field D
Field E
Field F
Field G
Field H

Now you build one DSO (DSO1) for DataSource 1 and another one (DSO2) for Datasource 2. But instead of heaving a flow (transformation) from
both the DSOs to the Target DSO selecting the data of the other DSO in a start-/end/expert routine you create only one flow from one of the
DSOs to the target where you implement the logic. In my example add a keyfigure to DSO2 (I call it ‘force delta’). Additionally
create a flow from DataSource 1 to DSO2, just updating the key and the keyfigure which should be set to addition and a constant value of 1.
This would force a delta from DSO2 to the Target for all affected keys and you need to implement the necessary logic only once in one flow.
That’s basically it. So no big deal, but it really saves some coding.

With this type of flow you achieve a delta going to DSO1 having the most actual data here. Additionally a delta going to DSO2 having the most actual data here also.
And in Addition with each independant delta of one of the DataSources there will be a delta going from DSO2 to the Target DSO so that you also have
the most actual data in your Target.

Here a short picture:

 Forced Delta

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Suresh Kuna
    Siegfried,

    It was nice blog which tells us to pick delta records from lookup DSO’s. here you considered scenario of one key field each from all DSO’s.
    I have a query here, suppose my DSO2 has 3 Key fields and my datasource1 has only one DSO2 keyfield object which does not contains all the DSO2 3 key field objects, How do I achieve and trigger deltas in this case from DSO2 to target DSO to make sure all deltas loaded properly with DSO1 lookups.

    Eg:
    Datasource1:
    Field A(Key)
    Field B
    Field C

    DSO2:
    Field C(Key)
    Field D(Key)
    Field E(Key)
    Field B
    Field G

    Target DSO
    Field C(Key)
    Field E (Key)
    Field B
    Field X
    Field Y
    Field Z
    Thanks
    Suresh

    (0) 
  2. Vidya Nair

    Hi Siegfried

    It would help if you could guide on how to use force delta method to say combine data from Order header DSO 1 and Order Item DSO 2 into DSO 3 with keys – header & item no both.

    Thanks

    VN

    (0) 

Leave a Reply