how to de reporting on links between projects RRS feed

  • Question

  • All,

    Whats the best known way to create a report on links between projects. I want to provide the PMO of my customer with a report, where they can see:

    1. Delivery dates

    2. whether changes are accepted

    3. Who is delivering to whom



    Monday, September 22, 2014 11:26 AM

All replies

  • Hi Sander,

    Are you using the deliverables/dependencies feature? In case you are, I'd suggest you to use the following tables from the Reporting DB:

    • [dbo.MSP_WssDeliverable]
    • [dbo.MSP_WssDeliverableToProjectLinks_UserView]
    • [dbo.MSP_WssDeliverableToTaskLinks_UserView]

    You'll find in the 2 last tables the relation between the delivrables. The delivery date will be found in the first table.

    Hope this helps,

    Guillaume Rouyre, MBA, MCP, MCTS |

    Monday, September 22, 2014 12:18 PM
  • Hi Sander,

    If you are using Task dependencies to drive the link between projects then you will need to look into the published schema to identify those links. There are 2 tables you can look at pub.MSP_TASKS where you can filter for the rows that have TASK_IS_EXTERNAL set to 1 and use the pub.MSP_LINKS to identify the linked item. Please note that you dependencies will appear twice (once for each project)

    Hope this helps


    Monday, September 22, 2014 4:13 PM