PerformancePoint Monitoring System Database
Updated: 2009-04-30
PerformancePoint Monitoring Server uses a single SQL Server application database. The database stores reports, data sources, dashboards, and other supporting metadata for dashboard elements. The various dashboard elements are created in Dashboard Designer and secured using a role-based security model, which is also stored in the database. Monitoring Server databases must run on SQL Server 2005 with the most recent service pack.
The stored metadata consists of the definitions for data sources, key performance indicators (KPIs), scorecards, analytic reports and views, and dashboards. Monitoring Server, Dashboard Viewer for SharePoint Services, Scorecard Viewer for Reporting Services, and Monitoring Plug-in for Report Designer (Visual Studio 2005) all retrieve dashboards and dashboard element definitions from this database. Dashboard Designer publishes dashboard and dashboard element definitions to this database.
Monitoring Server Configuration Manager provides the ability to install a new database to act as the Monitoring System database. This can be done either by creating it during initial configuration of Monitoring Server, or by having the database created in advance, before Monitoring Server Configuration Manager is started. The latter option is called provisioning.
The provisioning option supports the scenario in which creation of the database is managed centrally in a data center and the installing user does not have privileges to create databases. By choosing the provision option, you enable the database schema to be installed over the empty database. The database name can be customized.
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.