Is there a Data Model disctionary somewhere that we can reference to understand the differences in how different feilds we can report on are calculated or updated?

For instance, when running a report that totals all time entered for a project by task, there are different results depending on which column from the data model you try to take advantage of, see below:

[Presentation].[Projects].[Total Actual Work Hours] seems to give me an accruate total number of hours entered across the project.

How ever when I report the [Relational View].[Task].[Task Total Actual Work Hours] for each task, and add them up, I get a different number that above.

This must mean that the two fields are updated in a different way, or that there is time associated to the project in some what that has not yet made its way into any of the task records [Task Total Actual Work Hours].

If there is no data model disctinoary, any help on the example above would be helpful for the moment.

Thank You

As a quick follow up on this, it looks like that all Incremental work is not being included in the Task Total Actual Work Hoiurs...which seems to be a result of certain timeentries not being approved.  However, this still doesn't explain why the Total Actual Work Hours would be different for the tasks summation vs the Total Actual Work Hours on the project level.

Anyone know why there would be a difference?

 Hi,

We worked this one out. The Total Actual Work Hours for the task seems to only include task hours from users actually assigned to the task. If another user has added time but wasn't an actual assignee, it doesn't increment to it. I'm not sure if this is intentional or not.

I found we had to go straight to the timesheet entries in this case. Alternatively, you can modify the project role setting to prevent a user adding time to all tasks.

Cheers,

Charl

Bluenova