OLAP Cube: Resource Remaining Availability

[davis_mer]

We are trying to calculate remaining resource availabilty for all the
resources across all projects he/she is assigned in Portfolio Analyzer. We
have tried to insert a new column called "remaining availability" with the
follow calculation "Availability - Work = Remaining Availability". Here is
the issue : It shows remaining work (Task C) = 8hrs when work = 0hrs, which
is not true as the resource is already assigned to Task A and B with no
remaining availabilty. Also, with the inclusion of this calculation its
pulling in projects that resources are not assigned to (eg: Task D).

Availability Work
Remaining
Resource A
Project A 8 4
4
Project B 8 4
4
Project C 8 0
8 (??)
Project D (not assigned) 8 0
8 (??)

Thank you.

 

[Gary L. Chefetz [MVP]]

davis_mer:

Your question and your formula are not making a whole lot sense. The system
tracks work at a project level, however Capacity is not measured at the
project level, rather, it is the total of working hours for a specific
resource over a specific period of time. If a resource is available to work
8 hours on a given day, they are available to work that 8 hours for any
project, so displaying this by project simply doesn't make sense.

What are you really trying to see? Also, what is the actual formula you are
using? The one you posted is not a valid mdx syntax and would return no data
in the OLAP cube.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com