Project Server Creating database views RRS feed

  • Question

  • Hi All,

    We are using project server 2013. We need to create some database views to generate some complex report, what is the best way to create. I think if we create any custom views inside the project server databse, will be removed while applying the service pack.

    Thanks in advance, Taj

    • Edited by arun_2014 Monday, April 28, 2014 1:36 PM
    Monday, April 28, 2014 1:36 PM


  • Assuming you are talking for an On premise installation,

    You won't have problem if you create custom views within database as long as its referencing reporting objects, it is supported and documented on Technet

    Excerpt from Technet

    Schemas are documented only for the reporting tables and views. For an
    on-premises Project Server installation, you can add reporting tables
    and views for entities that are not defined in the Project database
    schema. You can also create separate databases for custom on-premises
    applications. Modification is not supported for the draft, published,
    and archive tables and views. Because the Project database is not
    directly accessible in Project Online, reporting tables and views cannot
    be modified. However, if you have a SQL Azure account, you can create
    separate databases for custom use with Project Online.

    Thanks | Sunil Kr Singh |

    Monday, April 28, 2014 7:21 PM