World be grateful if you can go through my below requirement and shed some light on the technical feasibility in QV
Details.
Objective is to Show the item availability across stores / brands etc.
Flow 1:
1) Select a week , say W10 2014
2) Opening Stock of a week is calculated as rolling stock. meaning say I select week 10 – 2014 stock number will be sum ( movement quantities ) where date <= 02-03-2014 (02-03-2014 is the last day of week 9) ( please note the stock fact is very well linked in the data model)
3) Now find all the items whose stock ( calculated as above) > 0 and count
I understand that this can be very well achieved fixing date range while loading and pre populating the items with a flag to indicate if the stock exists or not.
My question is, is there a way to make this dynamic to give user an option to select any week on the UI?
