Duplicates from change log to cube
My requirement is to load the deltas from change log to cube. But while loading the records in change log are not aggregated in cube. For example
Data in Change log:
Customer Amount Quantity Record mode
XYZ $100 2 N
XYZ $150 3
XYZ $100- 2- X
Data in cube is same as above.
Can you please explain why the records in dso are not aggregated in cube. We are in SP 16 and BI 7.0.