none
Time Dimension in Dashboard Designer? RRS feed

  • General discussion

  • Hello,

    How, when and where the Time Dimension of a Dashboard Designer report (OLAP Data source) can be used?

    Thanks


    • Edited by WLID1966 Thursday, November 10, 2011 1:26 PM
    Thursday, November 10, 2011 12:32 PM

All replies

  • Hi Wlid,

    the Time Dimension (to slice OLAP cube data) is only available in timephased cubes, i.e. Assignment Timephased, Resource Timephased and MSP_Portfolio_Analayzer (which combines those two) as well as both Timesheet cubes.

    Use MSP_Portfolio_Analayzer for assignment data and EPM Timesheet for timesheet data to analyse time and filter/slice by the time dimension.

    Kind regards,
    Adrian

    Thursday, November 10, 2011 3:21 PM
  • Hi Adrian,

    I'm afraid I did not explain my issue the right way. In fact, this Time Dimension is displayed (for some cubes) on a specific Time tab when we create a new Data Source in the Dashboard Designer :

    Here above I selected Time Dimension and the field Measures. What can I do with this field Measures on a timescale ?

    Thanks for your help.

     

    Thursday, November 10, 2011 3:57 PM
  • It looks like the data source that you are using might not have a properly formatted time dimension in it. You might want to make sure that the data source is set up correctly.

    To answer your question about how to use the Time tab in Dashboard Designer, here's an article that might help:

    Configure data sources to work with Time Intelligence by using Dashboard Designer
    This article contains links to procedures on how to configure different kinds of data sources to work with Time Intelligence in PerformancePoint Services.
    http://technet.microsoft.com/en-us/library/ff701697.aspx

    Regarding what you can do with Time Intelligence in PerformancePoint Services, here are a few articles you might find helpful:

    Extend PerformancePoint dashboards by using Time Intelligence
    http://technet.microsoft.com/en-us/library/gg610515.aspx

    Add a Time Intelligence filter to a PerformancePoint KPI
    http://technet.microsoft.com/en-us/library/gg610512.aspx

    Create a Time Intelligence filter by using Dashboard Designer
    http://technet.microsoft.com/en-us/library/gg410937.aspx

    Hope these resources help!

    Denise Stendera

    Writer, SharePoint Insights

     

    Friday, November 11, 2011 11:07 PM
  • Thanks a lot Denise

    .../... you can create a Time Intelligence dashboard filter to show information for rolling time periods, such as the last two years, the last six months, or the last 60 days.

    • Edited by WLID1966 Sunday, November 13, 2011 10:45 AM
    Saturday, November 12, 2011 9:32 AM
  • Hi Wlid,

    besides Denise's good links to Time Intelligence Filters, there are also Time Intelligence Connection Formulas. They are more interactive and I use them in a couple of dashboards.

    They present the user with a little calendar webpart which allows them to pick a date. This date can then be used to create a connection to a grid/chart/etc. using a formula and the selected date as base. We're using it for a timesheet report, the user picks a date and with a "month.firstday:month.lastday" connection, they given their timesheet of the selected month with work by day.

    Please see http://www.mssqltips.com/sqlservertip/1581/time-intelligence-post-formula-filter-template-in-performance-point-server/ as an example, read the whole post, the TI Connection Formula setup starts at Step 5. It's 2007, but the difference are minimal. Also, for a normal TI Filter, please see https://miketangoblog.wordpress.com/2011/01/04/adding-time-intelligence-to-your-performancepoint-dashboard/ for an example.

    Does that clear up your questions? PPS is a tough field, but it's very rewarding and these little sample walkthoughs can offer a lot of insight, the screenshots alone help a lot.

    Kind regards,
    Adrian

    Tuesday, November 22, 2011 10:14 AM
  • Hi Adrian,

    Thanks for this information!

    Tuesday, November 22, 2011 11:53 AM