All Resources with OverAllocated

[All Resources with Availability in gantt]

Hi Friends, I Need a report or view with All Resources Overallocated by
Day....
How do I its ?
the option in PWA : Resorce Center-View availability has limit 100 resources
and i have over 3500 resources... Thanks for help me...

 

[Micah]

Hello,
Do you have OLAP cube functionality? We use the Cube to look at over
allocated resources by creating calculated totals. Something like
[Meaures].[Capacity]-[Meaures].[Work] will give you negative hours if the
resource is over allocated. Show you could filter the view by time to see the
snapshot of the time you want and filter the view to show you the "bottom
20%" to show the lowest of these calculations. This is what we do, but it is
kind of complicated. I'm interested in more streamlined approches others may
have. Hope this helps

 

[All Resources with Availability in gantt]

I haven't Cube ...could be other solution ????

Hello,
Do you have OLAP cube functionality? We use the Cube to look at over
allocated resources by creating calculated totals. Something like
[Meaures].[Capacity]-[Meaures].[Work] will give you negative hours if the
resource is over allocated. Show you could filter the view by time to see the
snapshot of the time you want and filter the view to show you the "bottom
20%" to show the lowest of these calculations. This is what we do, but it is
kind of complicated. I'm interested in more streamlined approches others may
have. Hope this helps

Hi Friends, I Need a report or view with All Resources Overallocated by
Day....
How do I its ?
the option in PWA : Resorce Center-View availability has limit 100 resources
and i have over 3500 resources... Thanks for help me...

 

[Gary L. Chefetz]

It would be helpful if you explained what you're working with and what
version. If you have Project Server, you should setup the OLAP cube to
report on this data. If you don't like that option, you can write reports of
your own.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

"All Resources with Availability in gantt"

I haven't Cube ...could be other solution ????

Hello,
Do you have OLAP cube functionality? We use the Cube to look at over
allocated resources by creating calculated totals. Something like
[Meaures].[Capacity]-[Meaures].[Work] will give you negative hours if the
resource is over allocated. Show you could filter the view by time to see
the
snapshot of the time you want and filter the view to show you the "bottom
20%" to show the lowest of these calculations. This is what we do, but it
is
kind of complicated. I'm interested in more streamlined approches others
may
have. Hope this helps

Hi Friends, I Need a report or view with All Resources Overallocated
by
Day....
How do I its ?
the option in PWA : Resorce Center-View availability has limit 100
resources
and i have over 3500 resources... Thanks for help me...

 

[All Resources with Availability in gantt]

I tried with Cube Olap, but the new field "total capacity - total work"
display all result in negative... perhaps is wrong formula..i don't know....
¿ how i do thats report , where , how ? thks

It would be helpful if you explained what you're working with and what
version. If you have Project Server, you should setup the OLAP cube to
report on this data. If you don't like that option, you can write reports of
your own.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

"All Resources with Availability in gantt"

I haven't Cube ...could be other solution ????

Hello,
Do you have OLAP cube functionality? We use the Cube to look at over
allocated resources by creating calculated totals. Something like
[Meaures].[Capacity]-[Meaures].[Work] will give you negative hours if the
resource is over allocated. Show you could filter the view by time to see
the
snapshot of the time you want and filter the view to show you the "bottom
20%" to show the lowest of these calculations. This is what we do, but it
is
kind of complicated. I'm interested in more streamlined approches others
may
have. Hope this helps

:

Hi Friends, I Need a report or view with All Resources Overallocated
by
Day....
How do I its ?
the option in PWA : Resorce Center-View availability has limit 100
resources
and i have over 3500 resources... Thanks for help me...

.

 

[Ben Howard [MVP]]

This is one my blog titled "fun with analysis services". It was written a
couple of years ago, so I'm afraid you're in for a bit of a search -
http://appleparkltd.spaces.live.com/
--
Regards, Ben.

http://www.applepark.co.uk
http://appleparkltd.spaces.live.com/

I tried with Cube Olap, but the new field "total capacity - total work"
display all result in negative... perhaps is wrong formula..i don't know....
¿ how i do thats report , where , how ? thks

It would be helpful if you explained what you're working with and what
version. If you have Project Server, you should setup the OLAP cube to
report on this data. If you don't like that option, you can write reports of
your own.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

"All Resources with Availability in gantt"

I haven't Cube ...could be other solution ????


:

Hello,
Do you have OLAP cube functionality? We use the Cube to look at over
allocated resources by creating calculated totals. Something like
[Meaures].[Capacity]-[Meaures].[Work] will give you negative hours if the
resource is over allocated. Show you could filter the view by time to see
the
snapshot of the time you want and filter the view to show you the "bottom
20%" to show the lowest of these calculations. This is what we do, but it
is
kind of complicated. I'm interested in more streamlined approches others
may
have. Hope this helps

:

Hi Friends, I Need a report or view with All Resources Overallocated
by
Day....
How do I its ?
the option in PWA : Resorce Center-View availability has limit 100
resources
and i have over 3500 resources... Thanks for help me...

.

 

[Gary L. Chefetz]

Did you create this as a new calculate measure using the mdx syntax?
Remaining capacity is a custom measure I almost always add to the cube. You
do this from Server Settings page by selecting the Cube Configuration
selection. If your calculated measure is working and you're getting negative
numbers, then you may not have your capacity settings correct under
Additional Server settings where you set the date ranges for availability
calculations in the system.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

"All Resources with Availability in gantt"

I tried with Cube Olap, but the new field "total capacity - total work"
display all result in negative... perhaps is wrong formula..i don't
know....
¿ how i do thats report , where , how ? thks

It would be helpful if you explained what you're working with and what
version. If you have Project Server, you should setup the OLAP cube to
report on this data. If you don't like that option, you can write reports
of
your own.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

"All Resources with Availability in gantt"

I haven't Cube ...could be other solution ????


:

Hello,
Do you have OLAP cube functionality? We use the Cube to look at over
allocated resources by creating calculated totals. Something like
[Meaures].[Capacity]-[Meaures].[Work] will give you negative hours if
the
resource is over allocated. Show you could filter the view by time to
see
the
snapshot of the time you want and filter the view to show you the
"bottom
20%" to show the lowest of these calculations. This is what we do, but
it
is
kind of complicated. I'm interested in more streamlined approches
others
may
have. Hope this helps

:

Hi Friends, I Need a report or view with All Resources
Overallocated
by
Day....
How do I its ?
the option in PWA : Resorce Center-View availability has limit 100
resources
and i have over 3500 resources... Thanks for help me...

.