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

By | February 22, 2010

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

  • greg kramer

    kasper, rockstar.

  • Nice demo. Looks like you were in hyper drive. One thing on the 6 months back last year. You got the first part of the formula correct, but I believe you want previous year of current month. So it would looke like (Year-1).(Month-5):(Year-1).Month

    About Syntax for Time Intelligence expressions
    http://office.microsoft.com/en-us/help/HA102411381033.aspx

    Time Intelligence Formula Quick Reference
    http://blogs.msdn.com/performancepoint/archive/2010/01/21/time-intelligence-formula-quick-reference.aspx

  • Kasper de Jonge

    @Dan English
    Dan you are absolutly right ! thx for pointing it out te me, when you look at the preview it has way too many months 🙂

  • Matej Kralj

    Hi. Kasper. Great blog btw. Just something I was looking for, it has a lot of great information just my requirements.

    I have however a question regarding this topic the video above covers.
    In our company I’m experimenting with some powerpivot and lately also with dashboard (on sharepoint2010) test implementations.
    The reason I’m posting this under this entry is that I tried to recreate report by this video, but without success. After connecting to datasource and creating time filters, I try creating report (analytic chart as in the video) in Dashboard Designer.
    When selecting one ore more measures with any combination of dimension in design view I get “An unexpected error occured. Error 44797 This error has been logged for the administrator.”

    This started happening all the sudden, in the past I was able to overcome this phase and create some reports. Does anyone have an idea of what could be the reason for this? I searched the web for this error but without success. I figured I could try asking here.

    I’m almost certain there are some security issues involved, but I don’t know what else to change. I followed instalation guides posted both on this blog and also on “http://blogs.msdn.com/performancepoint”

    If needed I can also provide more information about the system and settings currently used.

    Thanks,

    Matej

  • Kasper de Jonge

    @Matej Kralj
    I recognize this error, i got it too sometimes. I also was unable to work around or solve this error i’m sorry to say. I suggest you wait for a week or what when the RTM becomes available. Since using the RC of Performance Point i did not have this message one single time.

    So i’m sorry i couldn’t help you here.

  • Matej Kralj

    Do you perhaps have any best practice regarding which user accounts are used for which service and which account is used to access the data and what access levels should these users have? I’m not a sharepoint expert(never used it also in the past) and there are so many options regarding this matter that also a poweruser like myself gets lost.
    I’m suspecting the problem is with permissions(perhaps some account passwords were changed in this time) or something :-S

    Thanks in any way.

  • Patrick B

    Kasper – Just wanted to express my gratitude as this tutorial was very beneficial to me on my current project. Thanks.

  • subha

    hi,

    I am having a report to design a dashboard with 2 filters and a report.
    while creating the filter and on selecting the dimension, the system is throwing th following error “unexpected system error has occurred” .

    Please help me to solve the issue.
    I am NT able to proceed further.

    Regards
    Subha