none
Report task list by date range RRS feed

  • Question

  • Hi all,

    I'm using Project Server 2013 to save our all working tasks. I'm also using Excel 2013 Power Pivot to connect to Data feed on Project server. Now I want to create a report for example weekly report that I can show how many tasks are running on a period of time, for example a week what ever those tasks are started before that week and finished after that week.

    I can do this when create a report on Project Pro, seleting task by date range. But cannot do this way because on project pro I can only report for one project, I need a report accross projects. But cannot do this by using Excel power pivot?

    Is anyone know how to do? please help me.

    thank you very much


    What will be will be!


    • Edited by Tudv Friday, April 11, 2014 11:15 AM typing mistake
    Friday, April 11, 2014 11:14 AM

Answers

  • Hi,

    Are you using Project Server 2013 on premises? In case you are, I'd suggest to use the OLAP cubes, which have the advantage to be timephased and to propose preconfigured Excel template in the PWA BI Center. The disavantage is that it is an asynchroneous process, meaning that if you build the OLAP DB every night, you'll have data from the day before.

    Below some references:

    • http://technet.microsoft.com/en-us/library/ff465344(v=office.15).aspx
    • http://msdn.microsoft.com/en-us/library/office/ee767687(v=office.15).aspx#pj15_Architecture_DAL
    • http://technet.microsoft.com/en-us/library/ff465342(v=office.15).aspx
    • http://technet.microsoft.com/en-us/library/ee662108(v=office.15).aspx
    • http://blogs.msdn.com/b/brismith/archive/2012/11/12/project-server-2013-requirements-to-build-an-olap-cube.aspx

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Friday, April 11, 2014 12:45 PM
    Moderator

All replies

  • Hi,

    Are you using Project Server 2013 on premises? In case you are, I'd suggest to use the OLAP cubes, which have the advantage to be timephased and to propose preconfigured Excel template in the PWA BI Center. The disavantage is that it is an asynchroneous process, meaning that if you build the OLAP DB every night, you'll have data from the day before.

    Below some references:

    • http://technet.microsoft.com/en-us/library/ff465344(v=office.15).aspx
    • http://msdn.microsoft.com/en-us/library/office/ee767687(v=office.15).aspx#pj15_Architecture_DAL
    • http://technet.microsoft.com/en-us/library/ff465342(v=office.15).aspx
    • http://technet.microsoft.com/en-us/library/ee662108(v=office.15).aspx
    • http://blogs.msdn.com/b/brismith/archive/2012/11/12/project-server-2013-requirements-to-build-an-olap-cube.aspx

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Friday, April 11, 2014 12:45 PM
    Moderator
  • Thanks for your all support, I can do it by combine startdate and finishdate when filter on Excel power pivot.

    What will be will be!

    Friday, April 18, 2014 4:13 AM