|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.|
Cube Build Service
This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.
The Microsoft Office Project Server 2007 Cube Build Service (CBS) manages the OLAP cubes for Project Server reporting. The CBS includes extensive event and trace logging to help find the cause of problems. The CubeAdmin Web service in the Project Server Interface (PSI) enables programmatic management and scheduling of cube building.
The OLAP database for Project Server includes a total of 14 default cubes for enterprise project management (EPM) reports, rather than the one cube in earlier Project Server versions. Following are the eight primary EPM cubes:
Following are the three default Windows SharePoint Services cubes:
Following are the three default virtual cubes that combine data from regular cubes:
MSP_Project_Timesheet combines the Assignment Timephased, Resource Timephased, and EPM Timesheet cubes.
MSP_Project_WSS combines Project Non-timephased, Issues, Risks, and Deliverables cubes.
MSP_Portfolio_Analyzer combines the Assignment Timephased and Resource Timephased cubes. The Portfolio Analyzer cube is backward-compatible with the Project Server 2003 MSP_Portfolio_Analyzer cube. You can add the resource availability calculated measure to MSP_Portfolio_Analyzer.
Project Server frequently updates the data in the OLAP cubes based on the scheduled times that are set in the Cube Build Settings page in Project Web Access. You can use the PSI to customize the cubes by adding custom fields. In addition, you can add external data to the cubes by using one of the event handlers (pre-build, post-build, and post-process). For information about adding custom fields as dimensions or measures to the OLAP cubes, see Local and Enterprise Custom Fields.
When you have added all your data to the cubes, you can use applications such as Microsoft Office Excel 2007 with its improved PivotTable reports and conditional formatting to build reports. If your Project Server farm includes Microsoft Office SharePoint Server 2007, you can publish the Excel workbooks or spreadsheets to Excel Web Services for thin rendering on any Windows SharePoint Services site.
You can also use tools such as SQL Reporting Services, Business Scorecard Manager, and others to create reports for your organization.
For information about the OLAP cube schemas, see the OLAPCubeSchemas.xls or OLAPCubeSchemas.xlsx file in the Project Server 2007 SDK download. For information about CBS events, see the Other Downstream Events section in Events for the RDB and the CubeAdminEventReceiver class.
How to: Calculate Resource Availability in OLAP Cubes shows examples of using Multidimensional Expressions (MDX) scripts to modify Project Server cubes.