Skip to Content

Regarding Pseudo delta or delta enabling in generic datasource

Hello,

I am on a support project and have been asked to analyse an infopackage which bring data for header only. Datasource is based on FM which has few fields including one date - created on field only.

Base table is VBAK which has ( ERDAT and AEDAT ),

how can I enable delta now ? I don't think it's possible on ecc side now as FM is already there.

Can I do something at BW side ? Please help and also can I see any improvement in IP runtimes after enabling Psuedo delta or I need to split IPs based on range as DS is full only.

thanks and regards,

Aman.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 26, 2018 at 07:57 AM

    You either handle the delta :

    • on the ECC side by activating it at the dataSource level and by adjusting the code of the MF.
    • on the BW side by playing with the selections on the creation and modification dates at the infoPackage level (supposing they are available as selection).
    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Frederic,

      As of now we are planning to split IPs into 4 IPs based on Sales order number range and see how it goes without coding on BW or extra coding on ECC DS.

      For delta, now I have to propose addition of "changed on" field in data source as no other option is there left.

      Again thanks for all the points and clarity.

      regards,

      Aman

  • Jul 26, 2018 at 04:27 AM

    Any updates..please..

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2018 at 11:41 PM

    Hi,

    I would bear in mind that "created on" is not necessary a timestamp (looks like only dd-mm-yyyy), and hence is not a very good criteria for selection. if you have na timestamp, then its ok though.. a logic such as

    if last_tmstp < current_time + x ...

    x would be the safety interval. Generic DataSources and similar are not my expertise, hence I just wanted to add this point above..

    Cheers!

    Add comment
    10|10000 characters needed characters exceeded