Ratio Actual Work / Administrative time (Project Server 2007) RRS feed

  • Question

  • Hi,

    In which OLAP cube in Project Server 2007 can we find for each resource, on a timescale, the two fields: "Actual Work" and "Administrative time" (holidays, sick leave, meetings...)


    Sunday, September 18, 2011 5:17 PM


  • Hello again!

    It is the Timesheet OLAP cube, but don't expect the admin time to be available as a 'measure'. Administrative time is a treated as a project and a timesheet class therefore a dimension and not a measure. See your other post regarding mdx expression for Actual vs Admin Time.

    You can create a Data Analysis view and use 'Timesheet Class' dimension which will show you the Admin tasks and 'Standard' classes and you can use actual work as the measure.

    Thank you,


    • Marked as answer by WLID1966 Sunday, September 25, 2011 8:25 AM
    Wednesday, September 21, 2011 9:23 AM