SAP Datasphere Delta flow with aggregation

[A_Bracco]

Hi all, 

we want to replicate a BW flow that from Datasource 0FI_AR_04 in delta loads DSO A.
from this DSO A the data loads with a delta DTP in another DSO B where the key figures are in sum with a part of the keys of DSO A. Below are the tables for the example.
it is necessary to replicate this flow in datasphere. We have created the tables ZA(DSO A) and ZB(DSO B) both with delta capture.

now SAP DSPH The flow from datasource to table ZA, works correctly because the key figures are aggregated by overwriting, but now there is the problem from ZA to ZB since in the transformation Flow it does not seem to be possible to aggregate the key figures by sum and it does not even aggregate by key since it returns an error on the unique key (see example in the table), how can we manage this type of flow on DSPH? is there a standard procedure or best case to follow?

error for sum aggregation

example aggregation flow in BW:

in DSPH doesn't work the collect for a part of the same table key before loading the data from ZA to target(ZB):

thanks.

[Martin_Kuma]

Hi, I wouldn't go the way of transformation flow at all. I would load the data into the inbound table, consume it via a view, on top of this view create a second with the aggregation. The second view would be persisted. 

I am not sure if you need CDC at all. You can load the BW ADSO via ODQ (replication flow), or create generic like extraction and load via data flow. The replication flow is preferred, but can be done only on ADSOs with change-log. 

Logically the system cannot aggregate on CDC as it needs to aggregate on the entire data set, not just the delta part. 

https://community.sap.com/t5/technology-blog-posts-by-members/sap-datasphere-bw-odp-delta-via-replic...

https://community.sap.com/t5/technology-blog-posts-by-members/sap-datasphere-delta-extraction/ba-p/1...

Cheers, 

Martin