Portfolio Analyser Views

[huw.brown]

Hi

We have got 2 Calendars in Project for normal Hrs and Weekend Working.
The various PM's book time against either depending is work is being
done in core hours or our of core hours.

I have produced a Portfolio Analyser view and exported to Excel as a
pivot table to show resource usage as a forward plan. I need to be
able to differentiate if the resource hours are booked for each of
these calendars, ie if a resource is overbooked during core working
hours. My current reports are skewed as weekend working is included
which is bumping up the Work, I need to be able to exclude any effort
against the weekend calendar.

Many thanks
Huw

 

[Finn]

To be honest given the cube is set up you cannot seperate work by the
calendar. You might find this easier using a customized version of the
resource usage view using the thick client in one of your projects,
probably an admin plan that everyone belongs to. You could then export
and manipulate this data in excel.

It isn't the way you want to get there but it will get you there.

Kevin