Chapter overview: Configure Office Project Server 2007 to use the Cube Building Service
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2016-11-14
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
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 Project Server 2007.