Great work Jim, and the rest of the contributors to the Project Server 2010 Software Development Kit (SDK). One of my favorite additions uses the new slicer feature of Excel 2010 to help you understand what is in the Reporting Database (RDB). This was thanks to Treb, and as an example, if you just want to see what date fields are in the MSP_EpmProject table:
How easy can it get? To summarize all the other good stuff:
The Microsoft Project 2010 SDK helps solution providers, value-added resellers, and other developers learn about new features in the Project 2010 client applications and the Project Server 2010 platform. The Project 2010 SDK shows how to extend and integrate Project Standard, Project Professional, and Project Server with other applications for enterprise project management (EPM). It features conceptual and "How to" articles, sample code, and programming references for the Project 2010 clients and Project Server 2010. The pj14sdk.exe download includes two help files: pj14SDK.chm (conceptual topics and managed code reference), and pj14_ReportingDB.chm (the Reporting database schema reference). Additional references for reporting include the OLAP cube schema reference (OLAPCubeSchemas2010.xlsx) and a pivot table to help select fields in the Reporting database (RDB_Field_Selector.xlsx). The WINPROJ.DEV.hxs file is an update for VBA Help in Project Professional and Project Standard, along with instructions for installation. The SDK download also includes the default Project Guide files, the XML schema for Project 2010, and the XML schema for the ChangeXML parameter for Statusing methods in the Project Server Interface (PSI). To help in developing with the PSI, the SDK download includes source files, scripts, and instructions to compile and update a proxy assembly for both the Windows Communication Foundation (WCF) interface and the ASMX (web services) interface of the PSI. In addition, updated XML files for Microsoft Intellisense include descriptions for many of the PSI types and members. Code samples in the SDK download include the following Microsoft Visual Studio solutions that relate to topics in the SDK:
Project 2010 SDK Download - http://www.microsoft.com/downloads/details.aspx?FamilyID=46007f25-b44e-4aa6-80ff-9c0e75835ad9&displaylang=en
Online (could be more up to date) - Project 2010 SDK in the MSDN Library
Online SharePoint 2010 SDK - http://msdn.microsoft.com/en-us/library/ee557253(office.14).aspx Just a reminder, although details are given for loading SharePoint 2010 on to Windows 7 for a developer workstation scenario, this is not supported or possible for Project Server 2010. Sure someone will try and prove me wrong – but not on the ‘supported’ bit.