时间表实际上是v发表的实际数据 [英] Timesheet actuals v's published actuals

问题描述

你好，

我希望有人已经看过这个，这可能会节省一些时间 - 懒惰我知道，但为什么要尝试重新发明轮子。 ;）

I was hoping somebody had already taken a look at this which might save me some time - lazy I know, but why try and re-invent the wheel. ;)

是否有人使用基本的SQL查询来比较每个任务的聚合时间表实际值，并将其与每个任务的已发布时间进行比较，以及如果存在差异，则输出。

Does anybody have a basic SQL query which compares aggregated timesheet actuals per task and compares it to the published time for each tasks, and outputs if there is a difference.

我们不断获取报告已发布数据的方案，但PM并未及时发布项目（我们可以继续这样做），所以希望能够提出一个简单的报告，我可以安排并通过电子邮件发送"温和"的报告。提醒。

We keep getting scenarios whereby we are reporting on published data, but PM's are not publishing their projects in time (this we can work on), so was hoping to come up with a simple report that I can schedule and email out for a "gentle" reminder.

谢谢，

Lee

推荐答案

你好

你可以通过报道多维数据集来做到这一点。

you can do it by reporting on Cubes.

你可以比较实际工作和实际工作Billable。

you can Compare Actual work and actual work Billable.

你可以快速，轻松地通过projtool发布项目。

and you can publish the projects by projtool, fast and easily.

这篇关于时间表实际上是v发表的实际数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！