Browse by Tags

The attached Project2013Reporting.exe file contains a draft release of the schema reference for the reporting tables and views in Project Server 2013. To install the files, run Project2013Reporting.exe. The next release of the Project 2013 SDK download will also include the reporting schema reference;...

The Project 2007 SDK download includes E-R diagrams of the major tables and views in the Project Server Reporting database. The Project 2010 SDK download does not include the Visio diagrams, although it does have the new RDB_Field_Selector.xls tool, along with the Project2010_ReportingDB.chm schema reference...

The Guide to creating SharePoint Composites includes a 73-page download that explains SharePoint Composites. To quote from the download, “A SharePoint Composite combines data, documents, and business process in a useful, productive way. … A SharePoint Composite is a ‘do-it-yourself’...

Microsoft Office Project Server 2007 and Microsoft Project Server 2010 internally manage cache synchronization by tracking revisions to major entities such as projects and maintaining records for deletions of those entities. Although the Draft, Published, and Archive databases in Project Server are not...

It’s our pleasure to present you refreshed versions of our one-stop technical resources related to · Upgrade and Migration to Project 2010 - http://go.microsoft.com/?linkid=9676814 · Business Intelligence for Project 2010 - http://go.microsoft.com/?linkid=9726143 These...

When we shipped Project Server 2007 we made sure that timesheet data was readily available to query in the Reporting Database, however one thing that we didn't do was make it super easy to spot a surrogate timesheet (defined as a timesheet entered on a team member's behalf by another Project Server user...

Hello, Christophe just released the reports that ship with the updated EPM 2007 VPC: http://blogs.msdn.com/chrisfie/archive/2008/04/10/new-sql-reporting-services-sample-reports-for-project-server.aspx Chris Technorati Tags: Project Server , Reporting

Hey, Here is a great post: http://projectserver.cz/cms/index.php?itemid=35 It shows how to get the connection string to the Project Server 2007 Reporting Database (and the other three databases which are not supported programming interfaces). This is extremely helpful when creating PSI extensions...

Leveraging the development aspects of Project Server 2007 spans a wide range of skills. PWA customizations (ASP.NET), workflow development, line of business applications integration using the PSI, extending Project Server functionality using server side events, specialized reporting from the Project...

Using Project Server 2007’s Reporting Database and SQL Server Reporting Services 2005 The attached report illustrates how to safely query the RDB to allow team members to see a read only view of task assignment data. We’ve picked a random task custom field to illustrate the concept. I’ve deliberately...

Introduction This custom solution builds on the Project Server 2007 server-side event model to cache a report-friendly copy of Project Local Custom Fields in the Reporting database. The following data is cached: Task Text Custom Fields (with and without lookup tables) by Project Lookup table...

Hello, As part of the development process for the next version of Project, we are heavily relying on Project to manage all the work that is happening across team. As part of the process, we require up to date status reports. All the work is spread across 40 project plans, so we cannot rely on PMs...

Introduction This post contains interim documentation for tables in the Published database of a RTM-edition Project Server 2007 installation. Entities in this schema are subject to change without notice. This documentation is made available on a “best efforts” basis, Microsoft Product Support Services...

It seems that somehow I messed up and the post " Scalable Issues & Risks Report " ended up showing up in the past. So in case you missed it: http://blogs.msdn.com/project_programmability/archive/2007/09/28/scalable-issues-risks-report.aspx Chris

Introduction Out of the box the Issues & Risks components of Project Server 2007’s collaboration functionality have an architectural problem which surfaces when 100’s of Project Server Workspace sites are created. This problem is forced by the need to allow flexibility in PWS placement within...

I just wanted to give a quick update about the Project Conference that is coming up at the end of October in Seattle. This is going to be our biggest conference ever! With sessions covering everything from how to get started with Project to managing a large EPM solution. There is entire track of sessions...

Jack Li has passed along a great tip on how to improve the performance of building the Project Server Data Analysis Cube: Recently we have worked with a big enterprise customer using Project Server. They ran into an issue where Project Server reporting component which uses Analysis Server ran very...

I have been asked many times how to get the task time phased data from the PSI. Unfortunately there is no way to get this through the PSI. I suggest that you either go to the RDB for this information or the cubes. Here is a quick example. I created a project with one task and broke the work down over...

It has been a while since I have done a blog post, so I figured I would share with you something that I am currently working on. We have run into the scenario where users are updating information on Project Workspaces and Project Manager wants to report on the data that the users are entering in the...

I just wanted to give everyone a heads up about the upcoming Project Conference. Details can be found here: http://www.msprojectconference.com/ There will be a Developer/IT Professional track that we will be presenting on a verity of development topics that cover the PSI, Events, Reporting and...

I have had many questions with regards to the Deliverables feature and reporting. If your not familiar with Deliverables, I suggest you take a look at my blog post on the Project blog: http://blogs.msdn.com/project/archive/2007/02/24/deliverables.aspx Just like all other project data, when a project...

I am not sure if this is a programmability post, but there have been many requests to do a post on writing a report in Excel that collects data from the reporting database. Since this will involve SQL and many developers who write code against Project Server will also need to write reports; this may...