Take a look at the following situation:
You have a cube, with the dimensions:
- products,
- months,
- datatype (e.g. buget)
- measure (costs)
The product-elements are changing within a couple o months. That is: in January we have a product "Chainsaw 101", but in June, it has been replaced by the model "Chainsaw 202".
The View contains the list of products. The Month is to be picked.
How can it be done, that the list of elements is correct? (Which means: in January I see only chainsaw-101, and in June only 202?) I tried some basic subsets, but the view didn't refresh automatically. I was thinking maybe of VB - but this should be the last resort.
btw: I do have a hierarchy (consolidated field) on products, and if I double-click it twice, the elements are updated, but this is exactly what I want to avoid. Especially because this view is to be deployed to WSS.
