Remaining Availability in Portfolio Analyzer

[MMM]

Is there an easy way to get remaining availability in portfolio analyzer
(other than extending the OLAP cube)? Considering that this is such an
important data item (how much balance capacity do I have?), I was expecting
it to be available in portfolio analyzer by default.

Also, is there some decent tool out there that can help me extend the OLAP
cube? One of the suggested tools on this forum (from bogdanov-associates.com)
does not seem to work.

 

[Gary L. Chefetz [MVP]]

MMM:

You can use a calculated field in an analyzer view.
[measures.availability] - [measures.work]

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

 

[MMM]

Thanks for the quick response Gary.

I have already tried the calculated field, but the problem is that if the
person is assigned more work than the Availability (e.g. by assigning a
different calendar to the task and selecting "Ignore resource calendar"),
then the calculated field shows negative value (as opposed to the "Remaining
Availability" field which shows 0 (zero) for all work more than the
availability).

MMM

MMM:

You can use a calculated field in an analyzer view.
[measures.availability] - [measures.work]

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

Is there an easy way to get remaining availability in portfolio analyzer
(other than extending the OLAP cube)? Considering that this is such an
important data item (how much balance capacity do I have?), I was
expecting
it to be available in portfolio analyzer by default.

Also, is there some decent tool out there that can help me extend the OLAP
cube? One of the suggested tools on this forum (from
bogdanov-associates.com)
does not seem to work.

 

[Gary L. Chefetz [MVP]]

Why is that a bad thing?

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

Thanks for the quick response Gary.

I have already tried the calculated field, but the problem is that if the
person is assigned more work than the Availability (e.g. by assigning a
different calendar to the task and selecting "Ignore resource calendar"),
then the calculated field shows negative value (as opposed to the
"Remaining
Availability" field which shows 0 (zero) for all work more than the
availability).

MMM

MMM:

You can use a calculated field in an analyzer view.
[measures.availability] - [measures.work]

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

Is there an easy way to get remaining availability in portfolio
analyzer
(other than extending the OLAP cube)? Considering that this is such an
important data item (how much balance capacity do I have?), I was
expecting
it to be available in portfolio analyzer by default.

Also, is there some decent tool out there that can help me extend the
OLAP
cube? One of the suggested tools on this forum (from
bogdanov-associates.com)
does not seem to work.

 

[MMM]

We are an engineering services provider, i.e. we sell engineering hours. Let
us say we have 100 engineers with availability of 40hrs/week. This means that
our total "standard" capacity is 100 Engs x 40 = 4000 hrs/week. This is the
target given to our sales force.

One sales person was able to sell services of 60 engineers at 40 hrs/week.
This results in the following equation:
Total Capacity: 100 Engs x 40 = 4000
Total Work: 60 Engs x 40 = 2400
True Remaining Capacity: 40 Engs x 40 = 1600
This is the same as "Capacity - Work" (4000 - 2400 = 1600) in my portfolio
analyzer view.

Now another sales person was able to sell services of another 15 engineers
but this customer works on a 6 day calendar (48 hrs/week). So these engineers
also have to work 48 hours/week (e.g. on overtime). Now the equation becomes:
Total Capacity: 100 Engs x 40 = 4000
Total Work: 60 Engs x 40 + 15 Engs x 48 = 3120
True Remaining Capacity: 25 Engs x 40 = 1000 (This is the same as Remaining
Availability in Project Professional Client).
But now "Capacity - Work" will become "4000 - 3120 = 880" which is not my
true remaining capacity.

I do not want to change the availability of a resource everytime such
assignments come up (or everytime the start date of an assignment is changed).

I have found one solution to this problem (although I am not sure if this is
the best one). I have used the following formula in the calculated field:

iif([Measures].[Work]>[Measures].[Availability],0,[Measures].[Availability]-[Measures].[Work])

This makes the remaining availability equal to zero for all those engineers
who are overloaded (working O/T).

Do let me know if this is the right approach.

Thanks

Why is that a bad thing?

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

Thanks for the quick response Gary.

I have already tried the calculated field, but the problem is that if the
person is assigned more work than the Availability (e.g. by assigning a
different calendar to the task and selecting "Ignore resource calendar"),
then the calculated field shows negative value (as opposed to the
"Remaining
Availability" field which shows 0 (zero) for all work more than the
availability).

MMM

MMM:

You can use a calculated field in an analyzer view.
[measures.availability] - [measures.work]

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project


Is there an easy way to get remaining availability in portfolio
analyzer
(other than extending the OLAP cube)? Considering that this is such an
important data item (how much balance capacity do I have?), I was
expecting
it to be available in portfolio analyzer by default.

Also, is there some decent tool out there that can help me extend the
OLAP
cube? One of the suggested tools on this forum (from
bogdanov-associates.com)
does not seem to work.

 

[Gary L. Chefetz [MVP]]

MMM:

Makes sense to me given the peculiarity you're dealing with. Unless you set
non-standard availability, project will always see the additional two hours
per day of availability as availability.

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

We are an engineering services provider, i.e. we sell engineering hours.
Let
us say we have 100 engineers with availability of 40hrs/week. This means
that
our total "standard" capacity is 100 Engs x 40 = 4000 hrs/week. This is
the
target given to our sales force.

One sales person was able to sell services of 60 engineers at 40 hrs/week.
This results in the following equation:
Total Capacity: 100 Engs x 40 = 4000
Total Work: 60 Engs x 40 = 2400
True Remaining Capacity: 40 Engs x 40 = 1600
This is the same as "Capacity - Work" (4000 - 2400 = 1600) in my portfolio
analyzer view.

Now another sales person was able to sell services of another 15 engineers
but this customer works on a 6 day calendar (48 hrs/week). So these
engineers
also have to work 48 hours/week (e.g. on overtime). Now the equation
becomes:
Total Capacity: 100 Engs x 40 = 4000
Total Work: 60 Engs x 40 + 15 Engs x 48 = 3120
True Remaining Capacity: 25 Engs x 40 = 1000 (This is the same as
Remaining
Availability in Project Professional Client).
But now "Capacity - Work" will become "4000 - 3120 = 880" which is not my
true remaining capacity.

I do not want to change the availability of a resource everytime such
assignments come up (or everytime the start date of an assignment is
changed).

I have found one solution to this problem (although I am not sure if this
is
the best one). I have used the following formula in the calculated field:

iif([Measures].[Work]>[Measures].[Availability],0,[Measures].[Availability]-[Measures].[Work])

This makes the remaining availability equal to zero for all those
engineers
who are overloaded (working O/T).

Do let me know if this is the right approach.

Thanks

Why is that a bad thing?

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

Thanks for the quick response Gary.

I have already tried the calculated field, but the problem is that if
the
person is assigned more work than the Availability (e.g. by assigning a
different calendar to the task and selecting "Ignore resource
calendar"),
then the calculated field shows negative value (as opposed to the
"Remaining
Availability" field which shows 0 (zero) for all work more than the
availability).

MMM

:

MMM:

You can use a calculated field in an analyzer view.
[measures.availability] - [measures.work]

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project


Is there an easy way to get remaining availability in portfolio
analyzer
(other than extending the OLAP cube)? Considering that this is such
an
important data item (how much balance capacity do I have?), I was
expecting
it to be available in portfolio analyzer by default.

Also, is there some decent tool out there that can help me extend
the
OLAP
cube? One of the suggested tools on this forum (from
bogdanov-associates.com)
does not seem to work.