Installing Microsoft PerformancePoint Server 2007 – Monitoring & Analytics Server (PPS-M&A) in a Standalone Machine

Introduction

Microsoft Office PerformancePoint Server 2007 is an integrated performance management application that enables you to monitor and analyze your business.

By providing flexible, easy-to-use tools for building dashboards, Office PerformancePoint Server 2007 can help everyone across your organization make informed business decisions that align with companywide objectives.

The Monitoring and Analytics features, which include Dashboards, Scorecards, KPIs (Key Performance Indicators), Reports, Filters, and Strategy Maps, are delivered via a Monitoring Server, which includes two client user interfaces: Dashboard Designer and SharePoint Web Parts. Dashboard Designer is downloaded from Monitoring Server, and enables business analysts or IT Administrators to:

• create data source connections
• create views that use those data connections
• assemble the views in a dashboard
• Deploy the dashboard to Microsoft Office SharePoint Server 2007 or Windows SharePoint Services.

Dashboard Designer saves content and security information to a SQL Server 2005 database that is managed through Monitoring Server. Data source connections, such as OLAP cubes or relational tables, are also made through Monitoring Server. Reports based on these data source connections are run and updated through Monitoring Server, however some reports, such as PivotTables and Pivot Charts, have independent connections to their source data (queries for these reports are not processed by Monitoring Server.)

After a dashboard has been published to the Monitoring System Database, it can be deployed to Microsoft Office SharePoint Server 2007 or Windows SharePoint Services. HTML pages that represent the dashboard content are stored in a document library and can be opened in a browser. When dashboards are opened in a browser, Monitoring Server updates the data in the views by connecting back to the original data source and retrieving the most current data.

PerformancePoint Monitoring Server comes with an API that allows developers to add extensions to the Dashboard Designer, such as custom reports, custom data source providers, custom wizards, and user interface extensions.

System Requirements for Monitoring Server

Hardware Requirement:

Minimum:

• 1 – Pentium 4 CPU
• 2.5 GHz
• 2 GB RAM
• 1 GB Available Disk Space
• 100 Mb Network Interface

Recommended:

• 2 Dual-Core 64-bit CPUs (x64)
• 4 GB RAM
• 5 GB Available Disk Space
• 7200 RPM IDE Drive
• 1000 Mb Network Interface

Supported Operating Systems:

• Microsoft Windows Server 2003 (SP2 and R2), 32-bit and 64-bit
• Microsoft Windows Server 2008, 32-bit and 64-bit
• Windows XP (excluding XPe), SP2
• Microsoft Vista™ (Business, Business N, Enterprise) 32-bit and 64-bit

Additional requirements

• Microsoft Internet Information Services (IIS) 5.1 (XP) 6.0, or IIS 7.0 with IIS Metabase and IIS 6 configuration compatibility, IIS 6.0 Isolation Mode
• Microsoft .NET Framework 2.0
• Microsoft ASPNet 2.0
• Microsoft ASPNet AJAX 1.0
• SQL Server 2005 Analysis Management Objects 9.0 SP2
• SQL Server 2005 Native Client 9.0 SP2
• SQL ADOMD.NET 9.0
• msxml6.msi + updates
• SQL Server 2005 SP2 Analysis Server OLEDB 9.0 Provider
• SQL Server 2000 Analysis Services Service Pack 4 – Build 2174 for Client Systems (to use SQL Server 2000 Analysis Services as a data source)

Supported browsers

• Microsoft Internet Explorer 6.0
• Microsoft Internet Explorer 7.0
• Microsoft Internet Explorer 8.0

Installation Procedure

1. Select “Install Monitoring Server” via setup. Initial setup wizard screen will be like as below. Click ‘Next’ to proceed further.

2. Agree to license terms.

3. Select the install location of the files.

4. Click ‘Install’ button.

5. Once setup is completed uncheck the “Run the Monitoring Server Configuration Manager” wizard and click Finish. We need to install ‘Hotfix’ and ‘Service packs’.

6. First, we need to install service pack 1. Click ‘Next’ to proceed further.

7. Agree to license terms.

8. Click ‘Install’ button.

9. Click ‘Finish’ button to complete the process.

10. Repeat from the step 6 – 9, for installing Hotfix and SP2.

11. We have installed all the service packs and Hotfix. Now, we can configure the Monitoring server.

12. Click ‘Next’ to configure.

13. If we have all the prerequisites for Monitoring Server installed we will see the following.

14. In the Installation Options screen choose stand alone server and ensure that all components are selected.

15. In the Database provisioning screen select the default values. Note you can choose to supply your own database names. Here we are using the default name of PPSMonitoring.

16. Next choose the web site configuration for the monitoring web site. Uncheck SSL if we are not going in for Secured socket layer and leave the port 40000.

17. Set the application pool identity for the Monitoring Server web application. We are using system administrator account for “PPSWebApp”. In a real deployment make sure you plan your accounts or use a different account for each web application according to best practice guidelines.

18. Now we have to specify a Windows SharePoint Services site collection for the “Dashboard Viewer” web part to be deployed.

19. Next, we need to select the Reporting Server instance for the report views to be deployed.

20. Once the settings are done, we can validate our options. We should see a similar screen as below.

21. Once we review the options, we can commit our configuration by choosing “Configure”.

22. A visual progress will indicate the configuring process as shown below.

23. Monitoring server has successfully installed.