Welcome to MSDN Blogs Sign in | Join | Help

October 2007 - Posts

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

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

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

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

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.
Posted by chrisfie | 1 Comments

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

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

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

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

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.

EPM & SharePoint Performance Counters

Following Joel Oleson’s blog post on SharePoint performance counters please find below a list of EPM performance counters. I’m sure you are all already monitoring these in your production environment! Front End Perf Counters Back End (SQL Server) Performance
Posted by chrisfie | 1 Comments

New EPM University Courses for Partners and Customers

http://www.msepmu.com Microsoft Enterprise Project Management (EPM) University is pleased to offer online courses designed to impart the required knowledge to successfully install, configure and deploy Office EPM Solution. Microsoft EPM University provides

Controlling the project workspaces list

By default when provision a Project Web Access site, the home page contains a webbox called “Project Workspaces” which display a list of all project’s WS that have been created. By default there are two ways to display the list of WS: “All Workspaces”

How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0

It’s all explained in this official MS knowledge base article: http://support.microsoft.com/kb/934838/en-us
Posted by chrisfie | 1 Comments
 
Page view tracker