Formatting Project Server Timesheet Cube field "Time" RRS feed

  • Question

  • Hi,

    We are running Actual Work reports for our organization and I am wondering about a formatting issue. Currently when using the Timesheet cube. We are using the field "time" to see certain time periods. 

    The issue is the time does not display the actual dates it just shows Week 1, Week 2, etc..

    Is there anyway to format or adjust this report to pull in the actual date for that week?



    Wednesday, February 26, 2014 4:42 PM

All replies

  • Hi BC88,

    A solution would be to use the "timesheet period" dimension instead of the "time" dimension. If you use a clear syntax (ie first day of the period) for the timesheet periods defined in the server settings\timesheet settings and default, then you'll have a more user-friendly display in your timesheet report.

    Another way ("less clean" I'd say) would be to make a correspondance table in another sheet of your workbook such as:

    week 1 | 2014-01-01 2014-01-08

    week 2 | ....

    Then you can write a "vlookup" formula in your main sheet to display in the cell above the week number the right dates coming from the correspondance table.

    Hope this helps.

    Guillaume Rouyre - MBA, MCP, MCTS

    Wednesday, February 26, 2014 4:52 PM
  • I think you might find that the Cube method of reporting weeks has some limitations- not only the week number format, but the way that it splits weeks that span across the beginning and end of months is also cumbersome. You could try the answer to the post below- using the reporting database instead of the OLAP Cube may give you the flexibility you want.

    Hope this helps!

    Elli J Project Solutions Specialist Blog:

    • Edited by ElliJ Thursday, February 27, 2014 7:56 AM
    Thursday, February 27, 2014 7:54 AM