Customizing Views in OLAP?

R

Rajan

Hi,

How do I customize OLAP to depict the resources hours and what projects can
be viewed in OLAP?

For example: John Doe is working in Project A,B and C. Jane Doe is working
on Project A, B, C, D and E.

Question:

1) What Projects are resources over-allocated in or what Projects are
over-allocating overall?
2) I have four developer types (C#, Java, C++ and Perl), How do I get a
view/report that tells me who knows C# and Java?

Basically, I wanna be able to manipulate data in Project Server using OLAP
views (just some type of report or query), such as questions from above.

Thanks
Rajan.
 
D

Dale Howard [MVP]

Rajan --

Here's a Portfolio Analyzer view that might be usedful to you:

Add the Resources field to the Row fields drop area
Add the Projects field to the Row fields drop area, just to the right of the
Resources field
Add the Time field to the Column fields drop area
Add the Availability and Work fields to the Total fields drop area
Add this view to the My Organization and perhaps the My Projects categories

This custom Portfolio Analyzer view will allow you to see each resource and
the projects to which each resource is assigned, and to be able to compare
Work vs. Availability. When Work exceeds Availability in any time period,
the resource is overallocated.

If you have created a custom enterprise Resource outline code that describes
each resource's primary developer skill, you can add this field to the
Filter fields drop area and then filter the view by developer skill. Just a
thought. Perhaps the others will have some ideas for you also.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the books on Project Server"
 
Top