Screencast: Build a PerformancePoint 2010 dashboard using a Time Intelligence filter

This screencast will show you how we create a dashboard on a SSAS cube in PerformancePoint 2010 using a filter with time intelligent functions:

A few important points:

  • use a Hierarchy to assign multiple Time Member Associations,the more levels you use the more functions are available. When you assign day you can use functions on day (like today), when you assign year you can use functions like nextyear.
  • The Time intelligent functions use the time settings of the server to determine the current day and calculate the functions.
  • You can map the time from your cube to any time you want, like in the demo you can map 2008 to 2010 to fool the functions
  • Use the formula in the  time filter to connect controls where available

Pretty though demo to do 10 minutes, please don’t hesitate to ask me questions here.

Big thanks to these blog posts:

http://consultingblogs.emc.com/davidfrancis/archive/2007/12/02/PerformancePoint-Time-Intelligence-_2D00_-BI-for-the-masses-Part-1.aspx
http://blogs.msdn.com/performancepoint/archive/2009/12/14/configuring-data-source-time-settings-for-time-intelligence.aspx
http://blogs.msdn.com/performancepoint/archive/2010/01/21/time-intelligence-formula-quick-reference.aspx

And Dan English to point out to me i have to use the Hierarchy to add multiple Time Member Associations at the Ms forum:
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/5f7f3e9b-1648-48c7-8cdf-8e3fb211b0ae?prof=required&ppud=4