locked
Filter by date range without using MDX in the report RRS feed

  • Question

  • Hii All,

    I wanna to make Time Intelligence connection formula filter to filter by start date and end date and without using MDX in the report.

    Please Help.

    Thanks

    Thursday, April 28, 2011 5:30 PM

Answers

  • If the requirement is to have the user select two dates and you are going to use an Analytical Chart or Grid setting up parameters in the MDX is the only option you
    have.

    Your other options are to leverage the Time Intelligence functionality to get at slices of time or use Time Intelligence Post Formula filters and do something dynamically
    on the fly.


    Dan English's BI Blog
    Friday, April 29, 2011 11:13 AM
  • To use predefined date ranges firstly you would need to configure Time tab under Data Source. Then you Time Intelligence formulas like Day-3:Day in your filter link formula (when connecting to filters)

    One reference is here:

    http://blogs.msdn.com/b/performancepoint/archive/2007/07/02/working-with-time-intelligence-in-performancepoint-monitoring.aspx

    Here is list of formula upon which you could improvise:

    http://blogs.msdn.com/b/performancepoint/archive/2010/01/21/time-intelligence-formula-quick-reference.aspx


    http://dailyitsolutions.blogspot.com/
    Saturday, May 7, 2011 6:16 PM

All replies

  • If the requirement is to have the user select two dates and you are going to use an Analytical Chart or Grid setting up parameters in the MDX is the only option you
    have.

    Your other options are to leverage the Time Intelligence functionality to get at slices of time or use Time Intelligence Post Formula filters and do something dynamically
    on the fly.


    Dan English's BI Blog
    Friday, April 29, 2011 11:13 AM
  • Thank you for your reply.

    I wonder if can explain more the 2nd option as I tried to use the syntax of the connection formula but "daytodate" doesn't work .

    I think it would be helpful if there is an example of applying date range using Time Intelligence functionality.

    Thanks again.

    Tuesday, May 3, 2011 12:05 PM
  • To use predefined date ranges firstly you would need to configure Time tab under Data Source. Then you Time Intelligence formulas like Day-3:Day in your filter link formula (when connecting to filters)

    One reference is here:

    http://blogs.msdn.com/b/performancepoint/archive/2007/07/02/working-with-time-intelligence-in-performancepoint-monitoring.aspx

    Here is list of formula upon which you could improvise:

    http://blogs.msdn.com/b/performancepoint/archive/2010/01/21/time-intelligence-formula-quick-reference.aspx


    http://dailyitsolutions.blogspot.com/
    Saturday, May 7, 2011 6:16 PM