World be grateful if you can go through my below requirement and shed some light on the technical feasibility in QV
Objective is to Show the item availability across stores / brands etc.
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?