Project Calendar Meta Data - How to identify the calendar and calendar properties via report builder 3.0 RRS feed

  • Question

  • Hi
    I am trying to write a report (SQL Server 2012 Report Builder 3.0) that will project a list of Projects and the Project Calendar they are using. I thought this field would be visible in the default EpmProject_UserView - I've been through other views and cannot see where this field is found.

    Related to this query - I need to identify the defulat calendar working hours per project but again there is no obvious meta data field where this can be identified.

    Currently the only option I do have is to manually check via MS Project App (2013)....

    Tuesday, December 9, 2014 2:02 AM

All replies

  • Hi Brendan,

    Project server reporting database doesn't contain the calendar info. The only supported way to use the PSI to read the calendar info from Published database.

    See this reply from Amit.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller |

    Tuesday, December 9, 2014 2:02 PM