Updated: 2009-04-22

This chapter provides information and directions for configuring Microsoft Office Project Server 2007 to use the Cube Building Service. This chapter does not include information about selecting cube configuration options (for example, selecting custom fields as cube dimensions or measures) nor does it include information about creating views for the cube data. For information about managing cube build configuration options and settings, see Managing the Cube Building Service in Project Server 2007.

In this chapter:

• Cube building process overview   Provides a breakdown of the steps involved in building an OLAP cube through the Office Project Server 2007 Cube Building Service. This involves processes that occur on the Project Server application server, SQL Server Analysis Services, and the Reporting database.

• Deployment configuration options for the Project Server 2007 Cube Building Service   Provides supported configuration options that are available to customers who plan to deploy the Cube Building service.

• Requirements for using SQL Server 2000 Analysis Services with the Project Server 2007 Cube Building Service   Provides information and procedures for configuring the Cube Building Service with SQL Server 2000 Analysis Services. Office Project Server 2007 is supported to use either SQL Server 2000 Analysis Services or SQL Server 2005 Analysis Services. This article describes permission and configuration requirements on the Project Server Application Server, Analysis Services, and the Reporting database.

• Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service   Provides information and procedures for configuring the Cube Building Service with SQL Server 2005 Analysis Services. This article describes permission and configuration requirements on the Project Server Application Server, Analysis Services, and the Reporting database.

• Requirements for using SQL Server 2008 Analysis Services with the Project Server 2007 Cube Building Service   Provides information and procedures for configuring the Cube Building Service with SQL Server 2008 Analysis Services. This article describes permission and configuration requirements on the Project Server Application Server, Analysis Services, and the Reporting database. It also describes error messages you can encounter while building cubes with this version of Analysis Services, and possible solutions for these errors.

Download this book