Browse by Tags

Tagged Content List
  • Blog Post: Project Server 2013 reporting database (RDB) schema reference

    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;...
  • Blog Post: Where in the SDK are the Visio diagrams for the RDB?

    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...
  • Blog Post: You can use Project with SharePoint Composites, too

    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’...
  • Blog Post: Project Server Cache Synchronization

    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...
  • Blog Post: ANNOUNCING: Project 2010 TechCenters on TechNet refreshed

    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...
  • Blog Post: Identifying Surrogate Timesheets in the Reporting Database

    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...
  • Blog Post: New SQL Reporting Services Sample Reports for Project Server

    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
  • Blog Post: Connection Strings…

    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...
  • Blog Post: Project Server 2007 - Project Server Developer Community Expanding

    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...
  • Blog Post: Implementing My Tasks “Read Only Custom Fields”

    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...
  • Blog Post: Reporting Database Extensions: Local Custom Fields Custom Code

    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...
  • Blog Post: Publishing Projects based off a Project Custom Field Value

    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...
  • Blog Post: Local Custom Fields

    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...
  • Blog Post: Check out the Post on Scalable Issues & Risks Report

    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
  • Blog Post: Scalable Issues & Risks Report

    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...
  • Blog Post: Project Conference 2007 is Quickly Approaching

    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...
  • Blog Post: Improve the Performance of Building the Project Server Data Analysis Cube

    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...
  • Blog Post: Getting at the Task Time Phased Data

    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...
  • Blog Post: Syncing Project Workspaces with the RDB

    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...
  • Blog Post: Project Conference

    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...
  • Blog Post: Creating Deliverable Reports

    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...
  • Blog Post: Using the Reporting Database and Excel – Part 1

    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...
Page 1 of 1 (22 items)