Using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service

Walks through the process of creating an Analysis Services repository, and then describes the configuration steps necessary for the Project Server 2007 computer and client computers in order to get the Cube Building Service working properly.

The Office Project Server 2007 Cube Building Service uses the technology provided by SQL Server Analysis Services to create a database containing several online analytical processing (OLAP) cubes that are used for data analysis reporting. After ensuring that configuration requirements are met, you need to manage additional tasks such as scheduling the cube build, specifying fields for cube data, customizing the OLAP cubes, and configuring access to the cube data.