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.