Here’s an example of a view that shows inventory that is ‘dead’ or not moving based on 2 different business rules.
A couple of things:
1. The view only shows me my dead stock which we’ve defined as – Anything that has averaged less than 100 units moved in the last 13 weeks, or anything that has 0 movement in the last 4 weeks. Of course you could define your own rules.
2. To put this rule in place we used the following Row axis filter. Axis filters are cool becuase they let you define complex filters on the multiple pieces of data from a particular axis – and they can be dimension or measure based.
Here is the Row axis filter applied in the view – you can see the filter funnel icon next to the rows in the top left of the view – you can get there via the main filter window or right click on the word Rows in the upper left.
[Measures].[Data5 (Avg 13 Wk Sales)]<100 OR [Measures].[Data2 (Last 4 Wk Tot Wk 35 to Wk 38)]=0
The other measures are pretty straight forward - if you have comments or questions post just post 'em and I'll get back to you.
This topic was modified 2 weeks, 4 days ago by Frank. Reason: link issue with image