Skip to Content
avatar image
Former Member

Code to sum up multiple record key figure values from one ODS to another OD

We've got two ODSs: ODS1 and ODS2 and ODS1 feeds data to ODS2 through update rule. In ODS1, multiple records could contain one same doc records and we would like to sum up a key figure value for these multip records with the same doc number in the update rule and populate a key figure (a sum-up value or total value) in ODS2 for this doc number. We wonder how the code would look like.

Welcome the valuable input!

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 04, 2006 at 04:23 AM

    Hello Kevin,

    In this case there is no need of a code. As in ODS2, contract number is a key and PO is not a part of key, you can have update type for the key figure as "Addition". Value for that particular key figure will be added for all the recordes with same contract number irrespective of PO number.

    Hope it helps.

    Regards,

    Praveen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 04, 2006 at 05:05 AM

    Hi Kevin,

    if 2nd ODS does not have PO then system will take care of it.

    hope it helps

    Vikash

    Add comment
    10|10000 characters needed characters exceeded