locked
Can anyone use Time Intelligence Post Formula in production? RRS feed

  • Question

  • Here is the issue, lets take a simple cube that is always one day behind in the date. Which I guess is probably 90 percent since Dw are generally not real time. If I setup my filter link to Day-1. The correct data will show but it will always be one day behind on the calendar control date picker.

    Can someone enlighten me? Is this by design, is there a way to get the calendar control to match the date passed in the filter link formula.

    Thanks,

     

     

    Friday, May 21, 2010 5:41 PM

Answers

  • Yes the filter link formula Day-1 would work and this is by design. But before you could use that you need to setup the Time in data source (you can find it under third tab 'Time'). On this screen you need to map the day from your time dimension to reference date.

    If you give reference date with 1 day lag you don't need to use Day-1, just Day would do. But if you map it to today's date then you need to use Day-1.

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

    http://dailyitsolutions.blogspot.com/
    Wednesday, May 26, 2010 1:20 PM
  • Even thought the Time Intelligence is a fairly neat feature in PPS I would still look at alternatives.  Since you want to control the time based on the ETL process and load you can setup a field in your date dimension that is used to set the Current Date, setup a named set in the cube to reference that [ like say Today ], and then you could reference that member [ like Today.Item(0) ] any way you want to generate additional named sets in your cube that you can utilize as filters.

    Just an idea.  I want to be able to control and define the current date, not base it off the server date/time.  Still a neat feature, unfortunately I just don't use it.


    Dan English's BI Blog
    Saturday, June 5, 2010 2:45 AM

All replies

  • Yes the filter link formula Day-1 would work and this is by design. But before you could use that you need to setup the Time in data source (you can find it under third tab 'Time'). On this screen you need to map the day from your time dimension to reference date.

    If you give reference date with 1 day lag you don't need to use Day-1, just Day would do. But if you map it to today's date then you need to use Day-1.

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

    http://dailyitsolutions.blogspot.com/
    Wednesday, May 26, 2010 1:20 PM
  • There is no mapping in the post formula, it is just a calendar control. Anyway even if it did what your suggesting, it still wouldn't work. A reference date on the data source is just a pointer to any date, it doesn't consider the date you point at to be the current date, although that would be nice. The current date is todays date and if your cube doesn't have real time data to today date you seem to be sol with the time intelligence post formula. If I am missing something please let me know.

     

    Thanks,

    Larry

    Tuesday, June 1, 2010 3:15 PM
  • Even thought the Time Intelligence is a fairly neat feature in PPS I would still look at alternatives.  Since you want to control the time based on the ETL process and load you can setup a field in your date dimension that is used to set the Current Date, setup a named set in the cube to reference that [ like say Today ], and then you could reference that member [ like Today.Item(0) ] any way you want to generate additional named sets in your cube that you can utilize as filters.

    Just an idea.  I want to be able to control and define the current date, not base it off the server date/time.  Still a neat feature, unfortunately I just don't use it.


    Dan English's BI Blog
    Saturday, June 5, 2010 2:45 AM