none
PerformancePoint 2010 time filter (date selection drop down) from date and to date? RRS feed

  • Question

  • Hi, I have PPS 2010 report. I would like to create time filter which can have date picker selection drop-down FROM date and TO date. and pass those dates in report filter.

    Any idea how to create time filter with date picker and how to pass those date from/to query. Thanks.

    Thursday, March 10, 2011 10:37 AM

Answers

  • This might help:

    From Date To Date in PerformancePoint Analytical Chart


    http://dailyitsolutions.blogspot.com/
    Thursday, March 10, 2011 11:58 AM
  • That is an inherent problem with PPS analytical reports, as soon as you modify the MDX section of a report analytical features get disabled. There is no way as of yet to add 2 date parameter to an analytical report without changing the MDX query.

    Other options you can look at is limiting the flexibility of date ranges like you can have predefined date ranges e.g. Today - 7 days, WeekToDate, MonthToDate etc. These would work on a single date filter (like calendar) but look up data for a range. Plus you would have all analytical features available.


    http://dailyitsolutions.blogspot.com/
    Sunday, March 13, 2011 11:38 AM

All replies

  • This might help:

    From Date To Date in PerformancePoint Analytical Chart


    http://dailyitsolutions.blogspot.com/
    Thursday, March 10, 2011 11:58 AM
  • Thanks for that. But blog mentioned that disadvantage is lose right click contextual features drill downs, decomposition tree etc. Any way to overcome/alternative for this problem. ???

    Sunday, March 13, 2011 10:07 AM
  • That is an inherent problem with PPS analytical reports, as soon as you modify the MDX section of a report analytical features get disabled. There is no way as of yet to add 2 date parameter to an analytical report without changing the MDX query.

    Other options you can look at is limiting the flexibility of date ranges like you can have predefined date ranges e.g. Today - 7 days, WeekToDate, MonthToDate etc. These would work on a single date filter (like calendar) but look up data for a range. Plus you would have all analytical features available.


    http://dailyitsolutions.blogspot.com/
    Sunday, March 13, 2011 11:38 AM