Date filter in PPS - 2010
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
February 19th, 2013 11:24pm

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

February 20th, 2013 8:14pm

Hi !

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

February 21st, 2013 6:21am

The date control can be found under Time Intelligence filters.

Free Windows Admin Tool Kit Click here and download it now
February 21st, 2013 5:54pm

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 ?

February 23rd, 2013 4:15am

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.

Free Windows Admin Tool Kit Click here and download it now
February 27th, 2013 12:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics