Before you start

Updated: 2009-04-30

Designing a Microsoft Office PerformancePoint Server 2007 topology should begin at the back end and move towards the front end. Define the number of users. Define the number of PerformancePoint Planning applications. Then determine the number of databases and cubes needed. Then build the topology plan from back end to front end.

Planning Server

When determining your Planning Server deployment, research and install additional application dependencies. Any applications that Planning Server depends on should be installed first. For example, if you are using Microsoft Office SharePoint Server 2007 for the templates and reports repository, then Office SharePoint Server 2007 should be installed before you install PerformancePoint Server. The same is true for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services.

SQL Server

Installing and configuring Planning Server creates two system databases. Creating a Planning application creates another database (an application database) and an Analysis Services cube. If you create a staging database for the application, that is one more database. Therefore, consider deploying the system databases on one computer running SQL Server and the application databases on another. Also, when you are building multiple model sites, multiple Analysis Services computers should be used.

The business intelligence technology stack

The following diagram illustrates how PerformancePoint Server integrates with other Microsoft products within the business intelligence technology stack.

Current Microsoft BI technology stack


This diagram is an excerpt from The Rational Guide to Monitoring and Analyzing with Microsoft Office PerformancePoint Server 2007, by Nick Barclay and Adrian Downes, and is property of Mann Publishing Group (978-1-932577-41-9), copyright November 2007, all rights reserved. No part of this diagram may be reproduced, stored in a retrieval system, or transmitted in any form or by any means—electronic, electrostatic, mechanical, photocopying, recording, or otherwise—without the prior written permission of the publisher, except in the case of brief quotations embodied in critical articles or reviews.

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 Planning Server.