PWA2007: Missing Actuals in My tasks (Statusing)

[Paul Goldmann]

Hi,

does anyboy know how to find out from a central point of view, which team
members have less actuals than capacity (availability)?

Thanks in advance
Paul

 

[Ben Howard]

You could add a simple calculated field into the MSP_Portfolio_Analyser cube.

The field would be called availability and the MDX would look like
[capacity]-[work]

Availabiliy is now available in the PWA OLAP views. You could connect to
the cubes using Excel and then just display resources where Availability > 0.

 

[Gary L. Chefetz [MVP]]

Paul:

From the Resource Center, select the resources you want to view, and click
View Availability on the tool bar.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project

 

[Paul Goldmann]

Hi Gary,

the view only shows work vs. capacity. So I cannot see the difference
between actual work and capacity. Am I missing something?

Paul

 

[Paul Goldmann]

Hi Ben,

this is close, how ever I used remaining avail=capacity-actual work

Thanks
Paul

--
Paul Goldmann

You could add a simple calculated field into the MSP_Portfolio_Analyser
cube.

The field would be called availability and the MDX would look like
[capacity]-[work]

Availabiliy is now available in the PWA OLAP views. You could connect to
the cubes using Excel and then just display resources where Availability >
0.


--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Hi,

does anyboy know how to find out from a central point of view, which team
members have less actuals than capacity (availability)?

Thanks in advance
Paul