未来几个月的剩余工作与工作 [英] Remaining work vs work in future months

问题描述

我试图理解为什么Project Server 2010报告数据库中的剩余工作和工作有所不同。 使用SQL查询查看报告数据库。我对未来几个月的数字略有不同 - 这项工作还没有开始的b $ b。我指的是表中的数据：

I am trying to understand why the remaining work and work are different in Project Server 2010 reporting database.  Using SQL Queries to look at the reporting database. I am coming up with slightly different numbers for future months - the work has not even started yet. I am referring to data in tables:

MSP_EpmAssignmentByDay_UserView.AssignmentWork和

MSP_EpmAssignmentByDay_UserView.AssignmentWork and

MSP_EpmAssignmentByDay_UserView.AssignmentRemainingWork

MSP_EpmAssignmentByDay_UserView.AssignmentRemainingWork

它出现PWA中的资源中心显示了整个分配工作。

It appears the resource center in PWA is displaying the total of assignmentwork.

我们刚刚在周末升级到Project Server 2010 SP1

We just upgraded to Project Server 2010 SP1 over the weekend

推荐答案

嗨哥斯拉，

我刚检查过你的我的一个DB上的声明：

I just checked your statement on one of my DB's:

select sum(Assignmentwork), sum(AssignmentRemainingWork)
from dbo.MSP_EpmAssignmentByDay_UserView
where TimeByDay  > getdate()+10

这篇关于未来几个月的剩余工作与工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！