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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

Hi Kevin,

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

hope it helps

Vikash