Hi all,
I have a ODS being fed from the source system and later that feeds a Cube. now the problem is, i see a sales order with order quantity as 1000012 - 400, when the same record is going to cube, i see it as, 1000012 - 100(-), 1000012 - 100(), 1000012 - 100(-), 1000012 - 100(). so the total order qty is totalling upto zero. Did any body came across same situation? How to ovrcome this problem? Do i need to change some setting in ODS? Any help would be appreciated and rewarded.
Thanks,
mav.
Hi Maverick,
There are couple of things you need to check -
1. Negative values in cubes are loaded from Change log ( 100- etc), check your Change log values if values in change log are the same in cube then there is no problem with update rules between ODS & Cube.
2. If values in change log are the correct ones then look for update rules between ODS & Cube (check routines).
3. If values in change log are not the correct then look for the ODS key because it will overwrite the values (data) & decide the changes for Cube based on this key.
hope it helps.
Vikash
Add a comment