Import Project actual hrs from OLAP cube RRS feed

  • Question

  • Hi all,

    We use Project Server, (PWA), and Project Professional 2016.

    Resources use an external bespoke timesheet system for actual project hrs. These are consolidated in a database reportable via an OLAP cube and Power BI.

    Is there a way we can interrogate the OLAP cube in the same way as we do with Excel and Pivot-tables?

    • Edited by BodgitNZ Monday, September 18, 2017 1:14 AM
    Monday, September 18, 2017 1:14 AM

All replies

  • Hello BodgitNZ

    Are you trying to report on the actual hours from the external database in OLAP cube or are you trying to push the actual hours into PWA?

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Monday, September 18, 2017 2:46 AM
  • Hello,

    Excel should be able to connect to the custom OLAP cube just like you are doing with Power BI. What issue the issue you get when trying to connect to your custom OLAP cube from Excel?


    Paul Mather | Twitter | | CPS | MVP | Downloads

    Tuesday, September 19, 2017 8:13 AM
  • Hi Michael, sorry for the delay. Either would be good but the latter would be ideal.
    • Edited by BodgitNZ Thursday, October 12, 2017 1:51 AM
    Thursday, October 12, 2017 1:51 AM
  • Hi Paul,

    Trying to import to Project in the same way as we do with Excel. Ideally 'automagically' updating resource actual hours

    Thursday, October 12, 2017 1:52 AM