Time Intelligence/Rolling Forecast and drilldown to certain periods RRS feed

  • Question

  • We have made a report with a Time Intelligence filter to get a rolling forecast over the last 12 months. We used the filter as a background filter and the report shows exactly what we want, so everything seems fine.
    However, when we deploy it into SharePoint and start to play around with it, we noticed a problem. It is still possible to drilldown to different dimensions, but it will ALWAYS use the time intelligence filter. This means if the last 12 months is shown and for example January shows some weird number, we cant drill down to just see that month... every reload will use the filter again and switch back to a 12-month view, no matter what we do. Is this because we used it as background filter? And is there any way to avoid this?
    Thursday, April 9, 2009 7:54 AM


  • Found the answer!
    Without a rolling forecast you use the month to filter by, when you then rightclick to "Show Only" that month, it works perfectly. When you use a rolling forecast filter, you first have to rightclick the month you want to see and select "Switch to June" (for example) and then rightclick and use the "Show Only" option, this solves the issue!
    • Marked as answer by Joel_i Thursday, April 9, 2009 9:34 AM
    Thursday, April 9, 2009 9:34 AM