none
Get task projected Cost day by day RRS feed

  • Question

  • I need to do an SSRS and I am trying to get the sum of task Cost from the beginning of the project to today's date. Is that possible? I can see on Project Plan the values per day but I am not sure how these values are stored in the server.
    Thursday, March 5, 2015 12:29 AM

All replies

  • Hi Seequest,

    You should look to the dbo.MSP_EpmAssignmentByDay_UserView.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Thursday, March 5, 2015 8:21 AM
    Moderator
  • Hi Seequest,

    Something like this should help get you started:

    Select			P.ProjectName
    			,	T.TaskName
    			,	A.AssignmentCost
    			,	A.TimeByDay
    from			[dbo].[MSP_EpmProject_UserView] P
    INNER JOIN		[dbo].[MSP_EpmTask_UserView] T
    ON				P.ProjectUID = T.ProjectUID
    INNER JOIN		[dbo].[MSP_EpmAssignmentByDay_UserView] A
    ON				T.TaskUID = A.TaskUID
    where			A.TimeByDay < GETDATE()
    Order by		A.TimeByDay

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Thursday, March 5, 2015 8:46 AM
    Moderator
  • Sorry, slightly update:

    Select			P.ProjectName
    			,	T.TaskName
    			,	A.AssignmentCost
    			,	A.TimeByDay
    from			[dbo].[MSP_EpmProject_UserView] P
    INNER JOIN		[dbo].[MSP_EpmTask_UserView] T
    ON				P.ProjectUID = T.ProjectUID
    INNER JOIN		[dbo].[MSP_EpmAssignmentByDay_UserView] A
    ON				T.TaskUID = A.TaskUID
    where			A.TimeByDay < GETDATE()
    Order by		P.ProjectName
    			,	A.TimeByDay

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Thursday, March 5, 2015 8:48 AM
    Moderator