Actual hours not matching between different cubes

[Terminator]

Hi,

Does any one know why the Actual hours (Actual Work Billable) in the
Project_Timsheet and other cubes not matching with the Timesheet cube?


Thanks

Terminator

 

[Gary Chefetz]

It depends on the extent of the discrepancy. Small discrepancies may be
calculation variances, only while larger deviations may indicate changing
values in the schedule or other distortion. Firstly, you should understand
that there are many reasons why actual work can change in a project
schedule. This can happen when Project Managers update progress in their
plans, or make changes that unbeknownst to them affect actual work. The time
you record in the Timesheet application, (Not My Tasks) is not subject to
accidental distortion, so you can trust this data if you care for it
correctly.

 

[Terminator]

Thanks for your response Gary..

I am only interested in knowing how many hours have been spent on the project.
In order to do this we are using the Actual Work Billable column but the
problem is that this col is showing different values in different cubes and
the discrepancy is huge. What is the best way to get this info? Maybe if we
can talk or email then I can walk you through or send you some screenshots.

Thanks

Terminator