Christophe Fiessinger's Blog Updates on Microsoft's Enterprise Social Networking (ESN) and Project Portfolio Management (PPM) offerings
Joel Oleson blogged today about: Evaluating SharePoint Partner Solutions and Applications built on SharePoint, he summarized five questions you should ask when evaluating a custom solution:
I strongly believe the same questions can be asked about any solution/application built on top of Project Server or Portfolio Server.
While delivering Project Server training in Beijing, a customer asked me to produce a report that displayed Milestones dates by Projects.
The assumption is that all projects are using the same project template and thus there is a specific naming convention for all Milestones.
The hard part was creating the T-SQL query from the Reporting database. You basically have to de-normalize the data and combine two UserViews (MSP_EpmTask_UserView and MSP_EpmProject_UserView)as shown below:
SELECT P.ProjectName AS Project, P.ProjectAuthorName AS Author,
P.ProjectStartDate AS Start, P.ProjectFinishDate AS Finish,
MAX(CASE WHEN TaskName = 'M1'
THEN TaskFinishDate ELSE NULL END) AS M1,
MAX(CASE WHEN TaskName = 'M2'
THEN TaskFinishDate ELSE NULL END) AS M2,
MAX(CASE WHEN TaskName = 'M3'
THEN TaskFinishDate ELSE NULL END) AS M3
FROM MSP_EpmTask_UserView AS T
INNER JOIN MSP_EpmProject_UserView AS P
GROUP BY P.ProjectName, P.ProjectAuthorName, P.ProjectStartDate, P.ProjectFinishDate
For instance for Proj4 it contains the following data:
I then created a new view in the Reporting database called MilestoneView, then went into Excel 2007 added a data connection my Reporting database and used the MilestoneView created earlier. Results looks like this (note I added some conditional formatting to display indicators):
Going further you could leverage Excel Services to render this report in your SharePoint Server farm.
[update November 19, 2008] the links below are obsolete, please refer to this link instead: Protecting and restoring the farm (Office Project Server 2007)
FYI two useful articles for any PS Administrator, were published on TechNet:
For more information about using the STSADM command-line tool with Office Project Server 2007, see Operations for the Stsadm command-line tool in Microsoft Office Project Server 2007.
FYI in case you missed it: http://support.microsoft.com/kb/948680/en-us
Bill Gates announced this morning at the SharePoint Conference a new online offering for SharePoint, following our Online strategy (Software + Services) :
Microsoft SharePoint Online provides a highly secure, central location where employees can efficiently collaborate with team members, find organizational resources, manage content and workflow, and gain the business insight to make better-informed decisions. Based on Microsoft Office SharePoint Server 2007, this Microsoft-hosted solution helps employees create and manage custom team and project-focused intranet sites for collaboration and document sharing. Users get the flexibility and customization they need to truly work efficiently across teams with tools like wikis, blogs, surveys, shared workspaces, and process workflows. And as a seamless extension of the Microsoft Office system, SharePoint Online is familiar and easy to use, and it enables collaboration within the applications your users already know.