I have a cube which contains both future forecast and past forecast (forecast created previously). There are three dimensions for the cube - Product, Market and Month
The requirement I got is to show both past forecast and future forecast in a chart, but only show the future forecast in a dataview which allows users to edit. Both chart and dataview are on the same screen, so any forecast changes can be reflected in the chart.
I noticed if I add a filter in the "Select" tab in the dataview, then the data entry is not allowed anymore. So, my question is how can I only show partial data of a cube in a dataview and allow data entry in the meantime? Thanks a lot.