Figuring out the ChangeXML format when using the ‘UpdateStatus’ method

The Statusing web service (Project Server Interface) in EPM2007 contains a powerful method called UpdateStatus. This method can be used to make changes to tasks and assignments; for instance: Actual Work, % Work Complete, … please refer to the ChangeList Schema Reference in the SDK for a complete list. To help you generate the XML…


Project Server Extended Report Pack from Project Conference

Following my presentation yesterday on reporting at the Project Conference in Seattle, please find below the “Extended” EPM report pack I demoed (leveraging SQL Server Reporting Services). Reports added are: Deliverables and Dependencies Issues and Risks Report Project Workspaces ProjectList PSI XML ResourceList PSI XML Risks – XML Data Srouce SSAS Timesheet Timesheet Audit 2…


How to track EPM Resource field changes in your Reporting Database

Leveraging the EPM 2007 Eventing service as well as the Reporting database here is a way of tracking all changes made to a Resource’s fields. A common request I heard from customers is the ability to track when a Resource changes from one node to another node in the RBS. Steps to do it (code download…


EPM Database Maintenance Tasks

After you deploy EPM 2007 in your production environment, I highly recommend you have a SQL maintenance plan in place. Maintenance tasks that should be in this plan include: Backup Check DB integrity Rebuild Index (-> update statistics) History cleanup Maintenance cleanup For more information on this subject please check the standard SQL documentation as…


Blog Using Windows Live Writer

Thanks to Brian Smith, I started using this tool today: Windows Live Writer instead of Copy & Paste to update my Community Server blog on MSDN.


Using a PSI Data Source in SQL Server Reporting Services

SQL Server Reporting Services 2005 (SSRS) has the ability to query data from XML data sources and thus from Web Services, for more information on this subject refer to Reporting Services: Using XML and Web Service Data Sources. Since EPM 2007 is architected around Web Services and specifically around the Project Server Interface (PSI), I…


Sample Code to Update a Resource’s Custom Field

Please find below a code sample I wrote that updates a Resource’s Custom Field of type Flag. You can call this method in a loop for instance to automatically reset a CF for all resources. 1: public static bool UpdateResourceCustomField(ResourceWS.ResourceDataSet resDS, Guid cfUID, bool flagValue) 2: { 3: Guid cfExists = GetCUSTOM_FIELD_UID(resDS, cfUID); 4: if…


Project Server Virtualization

A hot IT trend these days is running software applications on virtual environment, but before deploying EPM on a virtual environment please review the following KB article published on the subject: You may experience a decrease in performance when you run Project Server in a hardware virtualization software environment Windows Server System software not…


How to extract and view Timesheet Audit Data?

In EPM 2007 you have the ability to audit all timesheet transactions using the following flag: Server Settings >Time and Task Management > Settings and Defaults > Enable Timesheet Auditing Once audit has been activated, all timesheet changes get recorded in the following table in the Published database: MSP_TIMESHEET_ACTUAL_AUDIT Since the data is not in…


See You All at the Microsoft Office Project Conference!

The Project Conference in Seattle is three weeks away. I’m sure you have all registered! If not do so since we have great content lined up I’ll also be in Madrid for the EMEA Project Conference in December. Safe Travel.