locked
Project 2010: Creating a dashboard for each project RRS feed

  • Question

  • Hi,

    when you click Project Center you get an overview of your projects, e.g. http://p14app/projectserver/projects.aspx

    There you can find in the column project name your projects which are technically links. Clicking there brings you to the project details site, e.g. http://p14app/projectserver/Project%20Detail%20Pages/ProjectDetails.aspx?ProjUid=f4775f57-8099-454e-99cf-73a1551598e2

    Beside this there is an icon "Project Site" on the ribbon. Clicking there calls the page 

    http://p14app/projectserver/_layouts/PWA/Common/wssnav.aspx?Project=f4775f57-8099-454e-99cf-73a1551598e2  which forwards you immediatly to the the site of the project, e.g. http://p14app/ProjectServer/MyProject8/default.aspx.

    As you can see the Project GUID is not present anymore. But i need the GUID there to show a project specific dashboard. On this dashboard i have Reporting services reports which expect the GUID as input parameter.

    One idea is to save the GUID inside of the project specific site as a list and read it out there. This would mean creating a dashboard site with a list, save that as template, assign it as standard. Each time you create the site for a new project, it will have the list with the project GUID from the template, which needs to be updated with the specific one of the actual project.

    I haven't tried that yet. But i am wondering if there is not any better way/approch for doing this.

    Thanks in advance,

    Ayhan

    Thursday, October 14, 2010 8:47 AM

Answers

  • Hi Hans,

    i found out that you can create in MS Project 2010 Web Access under Enterprise Project Type/ Basic Project Plan a new Project Detail Page. This page can then customized with the webparts. For transmitting the URL parameter ProjUid you can use a Performancepoint URL Filter which delegate the parameter to the other sibling webparts on the page.

    Thanks for your help,

    Ayhan

    • Marked as answer by IanTenner Friday, October 22, 2010 12:02 PM
    Friday, October 22, 2010 12:01 PM

All replies

  • Hi Ayhan,

    The table MSP_EpmProject in the ProjectServer_Reporting database contains the field 'ProjectWorkspaceInternalHRef', which is the URL of the workspace. So you could use the URL of the workspace to query the MSP_EpmProject table to retreive the project GUID which you can use to link to other tables and retreive the data you need.

    This is just one idea. Other approaches are also possible.

    I hope this helps,
    Hans


    My EPM blog: Projectopolis
    Thursday, October 14, 2010 8:04 PM
  • Hi Hans,

    i found out that you can create in MS Project 2010 Web Access under Enterprise Project Type/ Basic Project Plan a new Project Detail Page. This page can then customized with the webparts. For transmitting the URL parameter ProjUid you can use a Performancepoint URL Filter which delegate the parameter to the other sibling webparts on the page.

    Thanks for your help,

    Ayhan

    • Marked as answer by IanTenner Friday, October 22, 2010 12:02 PM
    Friday, October 22, 2010 12:01 PM