Share via

Project Server 2013 reporting database (RDB) schema reference

  • Article

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; that will be announced here when the Project 2013 SDK update is published.

The Project Server 2013 RDB and OLAP cubes are accessible only with an on-premises installation of Project Server. For Project Online, you can use REST queries of the ProjectData OData service. The ProjectData service is also available with on-premises installations. For more information, see ProjectData - Project 2013 OData service reference in the Project 2013 SDK.

The attached file includes the following:

  • ProjectServer2013_ReportingDB.chm is the HTML Help build of the RDB reference. It includes only the tables, views, stored procedures (SProcs), and user-defined functions (UDFs) that are in the dbo user namespace of the Project Server database. 

Note: The draft, published, and archive database objects are not documented. Project Server 2013 combines objects from the four Project Server 2010 databases into one database. The default name of the database is ProjectService; different Project Web App instances can have different database names.

  • OLAPCubeSchemas2013.xlsx includes a worksheet for each of the 14 OLAP cubes that are available to build with Project Server 2013. Each worksheet lists the dimensions, measures, and properties that are available in the cube.

The Project Server 2013 RDB includes three new tables, 27 new views, and a total of 33 tables and views that include new fields. You can easily find the new items by searching, for example, for “New field” (with quotes). The following screenshot shows the new ProjectVisibilityMode field in the dbo.MSP_EpmProject_UserView view:

imgSearchNewField_84 

Project2013Reporting.exe

Comments

  • Anonymous
    January 28, 2013
    Hi, can we publish this on internet...

  • Anonymous
    January 28, 2013
    This is already on the internet. You can publish a link to this blog post, or download the file and freely distribute it. Keep in mind, the RDB reference is a draft; it will be published as part of the next refresh of the Project 2013 SDK download.

  • Anonymous
    March 19, 2013
    The RDB schema reference is now published in the March 2013 update of the Project 2013 SDK download file. See blogs.msdn.com/.../march-2013-update-of-the-project-2013-sdk-download-file.aspx

  • Anonymous
    May 27, 2013
    Thank you for this article :) It´s really helpful :) Sincerely, Martin from <a href=“www.grobmanschwarz.de/project  “> MS Project Server </a>

  • Anonymous
    April 24, 2015
    Greetings, I am working on a SSRS report for generating a report for daily totals for each task.  Could you please let me know which 2010 table would have this information?  published database specifically.   Regards,

  • Anonymous
    March 06, 2016
    Hi, Nice tool, I have requirement how get to know who modified last projects details and schedule in PWA,I am getting user name only who have checked out but after checking I am unable to get who have done changes in project details.By Databas i am getting only the user information who have checked out projects eg.  draft.MSP_PROJECTS.PROJ_CHECKOUTBY, draft.MSP_PROJECTS.PROJ_LAST_SAVED