Planned Work vs Work not matching, SP2

[DogLBer]

MSOP 2007, SP2, April CU
I have two Resource driven Excel reports one pointing at
MSP_Project_Timesheet and one pointing at Timesheet. The Timesheet report
which displays Planned Work appears to be correct. The one pointing at
MSP_Project_Timesheet has zero hoiurs in Planned Work for all dates, all
projects and has some projects with zero hours for Work where the same
project, same date had Planned Work (in Timesheets)and it has some projects
with Work hours but less than Planned Work and it has some projects that
match Work to Planned Work.
Further variables - SP2 was installed last week, but these reports were not
used much by the Resource Manager so the condition may or may not be related
to SP2.
All projects have been republished following SP2 and new cubes have been run.
No effect on the symptom.

So first question - Anybody know if this is SP2 related?
Second question - What is the definition of Planned Work and Work as they
relate to the Cubes? Shouldn't they be the same at the resource level? If the
resource is assigned to a Task I would expect their Work to be Planned Work.

 

[Mike Mahoney]

MSOP 2007, SP2, April CU
I have two Resource driven Excel reports one pointing at
MSP_Project_Timesheet and one pointing at Timesheet. The Timesheet report
which displays Planned Work appears to be correct. The one pointing at
MSP_Project_Timesheet has zero hoiurs in Planned Work for all dates, all
projects and has some projects with zero hours for Work where the same
project, same date had Planned Work (in Timesheets)and it has some projects
with Work hours but less than Planned Work and it has some projects that
match Work to Planned Work.
Further variables - SP2 was installed last week, but these reports were not
used much by the Resource Manager so the condition may or may not be related
to SP2.
All projects have been republished following SP2 and new cubes have been run.
No effect on the symptom.

So first question - Anybody know if this is SP2 related?
Second question - What is the definition of Planned Work and Work as they
relate to the Cubes? Shouldn't they be the same at the resource level? Ifthe
resource is assigned to a Task I would expect their Work to be Planned Work.

It is not an SP2 issue - 2007 timesheet cubes have always been
limited (incomplete data).
I believe planned work in Timesheet cubes reflects the planned work
included in the timesheet when it was created, and may or may not
relate to what is currently in the plan, and only relates to that time
period (not complete task). I think also there is a difference because
timesheet week can be different from "portfolio" week (w/e sat/sun
issue). Anyway generally only use thes cubes to display timesheet
data (not plan data).

regards

Mike

Mike

 

[DogLBer]

Mike, Thanks for your response. As it turns out I was researching the topic
Variance in MS this AM for some more reports and I ran across this "The
Variance field shows the calculated variance (variance: The difference
between baseline and scheduled task or resource information, they usually
occur when you set a baseline plan and begin entering actual information into
your schedule. Variances can occur in work, costs, and schedule.) between
planned and scheduled work, that is, the difference between the Baseline and
Work fields."
So it looks like Planned Work is baselined work which explains why it does
not match Work. Again, Thanks.

 

[Mike Mahoney]

Mike, Thanks for your response. As it turns out I was researching the topic
Variance in MS this AM for some more reports and I ran across this "The
Variance field shows the calculated variance (variance: The difference
between baseline and scheduled task or resource information, they usually
occur when you set a baseline plan and begin entering actual information into
your schedule. Variances can occur in work, costs, and schedule.) between
planned and scheduled work, that is, the difference between the Baseline and
Work fields."
So it looks like Planned Work is baselined work which explains why it does
not match Work. Again, Thanks.






- Show quoted text -

Dogi_Ber

In MSP there is work, actual work, remaining work and baseline work
(x11). Variance is Baseline(0) Work - Work
"Work" can be regarded as "planned" or forecast depending on your
audience

The PWA timesheet displays "planned" work for the time period and
reflects the last published data. It is not related to Baseline Work.
Focus on the basics in MSP before dissembling cube data which is far
from starightforward.

regards

Mike