Duplicates from change log to cube

[Former Member]

Hi All,

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.

Regards

Baba

[Former Member]

Hi Andreas,

We had this issue before SP16 also. Thats why we refresh (delete and reload full data) from other loads to same cube daily. I know that by compression it will fix the issue. If we do compression we cannot do delete and full load to cube. Can you think of any other solution to this.

Appreciate your help.

Regards

Baba

[Former Member]

Hi,

take a look at this SAP Note which is relevant for you:

Extracting from InfoProviders with navigation attributes

SAP Note Number: [1145673|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_whm/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d31313435363733%7d]

Regards

Andreas