how to Apply from - to date filer on PPS Dashboard RRS feed

  • Question

  • I would like to have From - To time filter to be applied on Performance Point Dashboard .. In other word , i want to filter the reports and scorecard result from 01-01-2011 to 24-03-2011 .

    Any Suggestion to have this filter .

    Adel Abu Madi
    Friday, June 17, 2011 4:04 PM


  • For the Analytical Report you can use this type of a setup using parameters in the report, just remember by modifying the MDX you will lose the interactivity options with the item - http://dailyitsolutions.blogspot.com/2011/01/from-date-to-date-in-performancepoint.html.

    For the scorecard though you don't have this option.  You would have to look at using slices of time instead of a To and From date option setup.  So you could look at say Last 90 days, Current Month, Previous Month, Current Year, Last Year, etc.  These types of options can be made available using the Time Intelligence feature.

    Dan English's BI Blog
    Wednesday, June 22, 2011 11:38 AM