locked
From Date and To Date Filters in PPS Dashboard RRS feed

  • Question

  • Is it possible to give FromDate and To Date filter in PPS dashboard.Pelase Help.

    I have a PPS Grid where I need to populate the data for a selected period From Date to To Date (2/2/2010 to 3/3/2010)
    How can I Do this in PPS dashboard without loosing the other PPS options (Actions/Show Deatils..etc)
    • Edited by cnuwin Thursday, March 4, 2010 10:44 AM typo
    Thursday, March 4, 2010 10:37 AM

All replies

  • On a scorecard this cannot be done. However this can be done on Analytical Reports on a dashboard.
    Friday, March 26, 2010 12:47 PM
  • I don't believe you will be able to do this and still be able to have the interaction that you are looking for in the Analytical report items.  You need to modify the MDX and setup parameters for this to work.  Once you do that you lose interaction as you have discovered.

    Might need to look at an Excel Services PivotTable or an SSRS report instead.  The other option would be to create slices of time that the user can reference and do this either in the TI PPS functionality or in the SSAS database.  Create slices like Yesterday, Last Week, Last Month, Last 30 Days, Last Month LY, YTD, etc.  By using these references you would not lose the interaction because you wouldn't need to modify the MDX.


    Dan English's BI Blog
    Friday, March 26, 2010 4:53 PM
  • Hi Cnuwin,

    I do not think it is possible directly. But you can create a time intelligence date filter in the dashboard and mention a range in FilterLinkFormula window example: - (Month.FirstDay:Day)
    This formula will return the data between first day of the month and current month.
    http://www.mssqltips.com/tip.asp?tip=1463
    http://office.microsoft.com/en-us/performancepoint/HA102446551033.aspx

    - Pushkar

    Monday, April 5, 2010 6:48 AM