Configure data sources to work with Time Intelligence by using Dashboard Designer


Applies to: SharePoint Server 2010 Enterprise

Topic Last Modified: 2010-12-08

When you want to use Time Intelligence in your PerformancePoint dashboards, make sure that you configure the appropriate data sources correctly to work with Time Intelligence. For example, suppose that you create a dashboard filter that uses Time Intelligence, and you want to connect it to multiple reports and scorecards. The data sources that are used for those items must all be configured to work with Time Intelligence. Otherwise, the dashboard filter will not function correctly.

When you configure a data source to work with Time Intelligence, you specify the values that determine how time will be interpreted for each data source. After a data source connection is created in PerformancePoint Services, the time properties are set on the Time tab. Tabular data sources, which include Excel Services workbooks, Microsoft Excel workbooks, SharePoint lists, and Microsoft SQL Server tables, have a different set up page for their time properties compared to SQL Server Analysis Services data sources.

In this section: