Monitoring Server: supported data sources

A multidimensional data source (often referred to as a cube) is a set of data that is organized and summarized into a multidimensional structure, which is defined by a set of dimensions and measures. A cube usually corresponds to a functional area of an organization, and cubes are designed to meet the business analysis needs of that functional area.

Monitoring Server supports Microsoft SQL Server Analysis Services (SQL Server 2000 Analysis Services and SQL Server 2005 Analysis Services) as a multidimensional data source.

For analytical grids and charts, only SQL Server 2005 Analysis Services is supported.

A tabular data source allows the user to connect to a table of data with one or more columns and then define the columns in the table structure as either dimensional or factual data. Defining the data in this way allows users to consider the tabular data source as they would a multidimensional cube for the Scorecard Report view.

Monitoring Server supports the following tabular data sources:

• Excel 2007 (workbook)

• SharePoint list (Windows SharePoint Services 3.0 or Office SharePoint Server 2007)

• Excel Services (Excel Services is only supported on installations of Office SharePoint Server 2007 Enterprise Edition)

• Microsoft SQL Server 2000 or SQL Server 2005 (tables or views) and ODBC

Analytical grids and charts are not supported on tabular data sources.

This topic is included in the following downloadable book for easier reading and printing:

• Monitoring Server Planning and Architecture Guide for PerformancePoint Server 2007

See the full list of available books at Downloadable content for PerformancePoint Monitoring Server.