How to analyze categories of task/assignment in Portfolio Analyzer

[Weerayuth S.]

Dear Sirs/Madams

Please anyone help/suggest?
I would like to be able to analyze task/assignment categories in my
enterprise via Portfolio Analyzer and see the graph.

For example, I wanted to have field named "Task Catagory" with values such
as Meeting, Problem Solving, Support, Self Study, etc and be able to analyze
it in Portfolio Analyzer. By this, I will be able to analyze how many hours
my resources spent in Self Study, Meeting, etc and show it in Graph for
executive.

I have tried using Enterprise Task Outline Code, and then I realized that I
can not use Enterprise Task Outline Code for Portfolio. (Only Resource and
Project Outline Code can be used with Portfolio.)

Any suggestion? I really need help.

Thank you very much in advance.

Weerayuth S.

 

[Marc Soester [MVP]]

You are not able to achieve this out of the box, but there is a great 3rd
party tool that will extend the Portfolio Analyser allowing you to report
against tasks ( and task outline codes and custom fields).

Check out this link:
http://www.bogdanov-associates.com/eng.asp?rubr_id=484

Hope this helps

 

[Weerayuth S.]

Dear Marc

Thank you for the answer.
At first glance this is kind of bad new for me, since project server can not
analyze task level of outline code. I will find more detail about your
suggested 3rd party product. Hope it's not expensive. This seems, small hope
for me.

Appreciated your kind help.
BR
Weerayuth S.

 

[Marc Soester [MVP]]

For the value that you get it is very reasonably priced. We have implemented
this tool many times on customer sites and they are all very happy with it.
The only "bad" thing is that the cube build will take longer ( much longer
if you have many many tasks and projects), but an overnight run will always
be sufficient

--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com

 

[James Fraser]

Dear Marc

Thank you for the answer.
At first glance this is kind of bad new for me, since project server can not
analyze task level of outline code. I will find more detail about your
suggested 3rd party product. Hope it's not expensive. This seems, small hope
for me.

I know this may not help you, but it is also worth pointing out that
task level custom fields can be easily included in the OLAP data in
Project Server 2007.


James Fraser

 

[Bonnie]

I'm running project server 2007 and having difficulty trying to generate the
report using a custom field.

I'm currently generating timesheet data using the EPM timesheet cube and had
a question about how to make a field available for the pivot tables in data
analysis.

At the task level, I created a lookup field that identifies that task with a
task code. These task codes are used across projects.

When doing the EPM Timesheet cube, I can create my report using my project
as filters, but I haven't been able to do so with the task filters. How do I
get that filter data to appear?

Any idea? Help would be greatly appreciated!

 

[Barbara - Austria]

Hi Bonnie,

It is not possible to use custom fields in cubes Timesheet and EPM
Timesheets. You could only use MSP_Project_Timesheets, in that cube you
acn use custom fields if you made them available in cube configuration.
For more information on differences of Timesheet cubes have a look at
Gary's great article
http://www.projectserverhelp.com/Lists/Posts/Post.aspx?ID=122.

Regards
Barbara

Am 04.03.2010 00:56, schrieb Bonnie: