Date filter in PPS - 2010 RRS feed

  • Question

  • I want to display two Time filters where the user can select a "To Date" and a "From Date" and the scorecard and reports will be filtered to records that fall 'between' these two dates. Is this possible and if yes, how?


    Tuesday, February 19, 2013 8:24 PM

All replies

  • Unfortunately it cannot be done with a scorecard but it can be done for the reports. Following is how:

    From Date To Date in PerformancePoint Analytical Chart

    • Edited by Umair.Khan Wednesday, February 20, 2013 5:16 PM
    Wednesday, February 20, 2013 5:14 PM
  • Hi !

    Do we need to have SP-2 for this date control ?


    Thursday, February 21, 2013 3:21 AM

  • The date control can be found under Time Intelligence filters.

    • Edited by Umair.Khan Thursday, February 21, 2013 2:55 PM
    Thursday, February 21, 2013 2:54 PM
  • Hi !

    The Date COntrol will not have any dimensiona associated know ? so I can create date control and how do i link to the dashboard ?

    We need to pass to the MDX query as [Paiddate].[Date].&[2012-01-01]

    Let me know if i can create greater than condition in filters ?


    • Edited by Bhadri1991 Saturday, February 23, 2013 1:16 AM
    Saturday, February 23, 2013 1:15 AM
  • You cannot have the date control without a Time dimension. The Time Intelligence used the Time tab mapping under data source. You can treat your [Paiddate] dimension as Time dimension, if possible.

    Alternatively you can create a drop down filter with all your non empty dates sorted descending and link that with the dashboard and reports.

    Tuesday, February 26, 2013 9:27 PM