none
Review Teams Completed Tasks RRS feed

  • Question

  • Please excuse ny ignorance as I am just learning PWA.

    WHat is the best way to look at a daily report showing what tasks have been completed accross various projects for the day & what tasks havent?

    Thanks in advance

    Friday, February 17, 2012 10:15 AM

Answers

  • If I were you, I'd develop an Excel report to do that.  That's the easiest
    way to look across tasks within multiple projects.
     
    1) Define a SQL query to pull the data from the Published database.
    2) Use Excel to surface the SQL query.
    3) Add the report to the BI Center and view either in Excel or in the browser.
     
    With a little SQL experience, it woudn't take very long.
     
    Your main challenge is ensuring that the PMs have actually updated the schedule
    on a daily basis to reflect what's completed.
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    • Marked as answer by tango2310 Sunday, February 19, 2012 5:45 AM
    Friday, February 17, 2012 12:19 PM
    Moderator

All replies

  • If I were you, I'd develop an Excel report to do that.  That's the easiest
    way to look across tasks within multiple projects.
     
    1) Define a SQL query to pull the data from the Published database.
    2) Use Excel to surface the SQL query.
    3) Add the report to the BI Center and view either in Excel or in the browser.
     
    With a little SQL experience, it woudn't take very long.
     
    Your main challenge is ensuring that the PMs have actually updated the schedule
    on a daily basis to reflect what's completed.
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    • Marked as answer by tango2310 Sunday, February 19, 2012 5:45 AM
    Friday, February 17, 2012 12:19 PM
    Moderator
  • Thanks Andrew,

    Do you have a sample or reference I could go to on how/sample of sql query?

    Sunday, February 19, 2012 5:47 AM
  • If you go into SQL Management Studio in your DEV environment, open the Reporting Database, and right click on Views to create a new one, you should be able to just create one using the interface.

    You'll want the EPMTasks_UserView and the EPMProjects_UserView as your source data.


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    Sunday, February 19, 2012 1:04 PM
    Moderator