none
Project Server 2007 - is Administrative Time reportable via the reporting database? RRS feed

  • Question

  • If Administrative Time is reportabel via the reporting database, which data structures might I use?

    Thanks
    Andy Novak
    University of North Texas

    Wednesday, March 16, 2011 10:37 PM

Answers

  • Hi Andy,

    are you looking for something like this?

    SELECT     TOP (100) PERCENT dbo.MSP_TimesheetProject.ProjectName,
                          CASE dbo.MSP_TimesheetClass.ClassName WHEN 'Standard' THEN dbo.MSP_TimesheetTask.TaskName ELSE dbo.MSP_TimesheetClass.ClassName
                           END AS TaskName, dbo.MSP_TimesheetResource.ResourceName, dbo.MSP_TimesheetActual.ActualWorkBillable,
                          dbo.MSP_TimesheetActual.TimeByDay
    FROM         dbo.MSP_Timesheet_OlapView INNER JOIN
                          dbo.MSP_TimesheetResource ON
                          dbo.MSP_Timesheet_OlapView.OwnerResourceNameUID = dbo.MSP_TimesheetResource.ResourceNameUID INNER JOIN
                          dbo.MSP_TimesheetActual INNER JOIN
                          dbo.MSP_TimesheetLine ON dbo.MSP_TimesheetActual.TimesheetLineUID = dbo.MSP_TimesheetLine.TimesheetLineUID INNER JOIN
                          dbo.MSP_TimesheetProject ON dbo.MSP_TimesheetLine.ProjectNameUID = dbo.MSP_TimesheetProject.ProjectNameUID INNER JOIN
                          dbo.MSP_TimesheetTask ON dbo.MSP_TimesheetLine.TaskNameUID = dbo.MSP_TimesheetTask.TaskNameUID INNER JOIN
                          dbo.MSP_TimesheetClass ON dbo.MSP_TimesheetLine.ClassUID = dbo.MSP_TimesheetClass.ClassUID ON
                          dbo.MSP_Timesheet_OlapView.TimesheetUID = dbo.MSP_TimesheetLine.TimesheetUID
    WHERE     (dbo.MSP_TimesheetProject.ProjectName LIKE N'admin%')
    ORDER BY dbo.MSP_TimesheetActual.TimeByDay DESC

    Regards
    Barbara

    Thursday, March 17, 2011 4:42 AM
    Moderator