Administrative Time Not Included in Measure in OLAP Cube? RRS feed

  • Question

  • In working with the available information in the "Virtual Cube" MSP_Project_Timesheet (Combines the Assignment Timephased, Resource Timephased, and EPM Timesheet cubes, per the OLAPCubeSchemas2010.xlsx spreadsheet), it looks as if the Actual Work Billable/Non Billable measures do *not* include Administrative time that was submitted in the Timesheet.  The Planned Work measure *does* include any Administrative time for that period in the Timesheet.

    Is this correct/by design?

    Any help is appreciated here...thanks! - M

    Note: I found this thread (Admin time not in OLAP cube EPM?) but it doesn't address if the actual measure contains all time, including Admin.  Thanks! - M

    Michael Mukalian | Jan 2010 - Dec 2010 MVP SharePoint Services | MCTS: MOSS 2007 Configuration |

    Thursday, May 22, 2014 12:14 PM

All replies

  • Actually, as far as I can remember, even Planned work does not include any administrative time. The EPM_Timesheet dimensions only carry Standard time.

    If you need to report on Admin time also, you should use the Timesheet Cube.

    Prasanna Adavi,PMP,MCTS,MCITP,MCT

    Thursday, May 22, 2014 1:45 PM
  • Just adding to what Prasanna already said, in order to get the admin time in your OLAP cubes, you will have to extend your OLAP cube or instead hit the reporting DB for getting the admin time

    Thanks | epmXperts |

    Thursday, May 22, 2014 3:35 PM
  • Hello,

    I'm experimenting the same 'problem' with Project Sever 2013

    How did you response  it ?

    Have you add another dimension to the cube ?

    Many thanks in advance for your kind answer.

    Best regards


    Monday, February 1, 2016 4:18 PM