Monitoring Server: supported data sources
Monitoring Server supports two kinds of data sources: multidimensional and tabular.
Multidimensional 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.
A SQL Server 2000 Analysis Services data source is not supported with the 64-bit version of Monitoring Server.
For analytical grids and charts, only SQL Server 2005 Analysis Services is supported.
Tabular data sources
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.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for PerformancePoint Monitoring Server.