I have inventory data coming from legacy syste.
I have the following fields.
Date Mtrl Qty.
As this is coming daily and i would like to keep the history in the ODS as well as cube. How can i make Qty as non cumulative with out Inflow / Out flow.
I should be looking at the reports based on wk, month and qtr.