Data Analysis View Creation Question - MSPS 2007

[Project Server Slave]

Hello,

I am needing to create a customized view for a client. They want a
view which shows the resource, then listed underneath them, the
projects they are assigned tasks on, then underneath that, their
availability and capacity. They also want the project owner to be
displayed in a fiend for each project, then also the work for each
project, for each day of the week ,Monday through Friday.

I see a couple issues with creating this view. Not all of the values
I require are in the same cube, so does this mean that I have to
extend the cube to hold the fields that I require? Is there any other
way to have a cube hold the resource list, project list and project
owner fields, etc?

Is there also a way to show the current week, like M-F, without having
to manually select the week in the view? I'm pretty sure that this
will require some customization, but I just need to know what the next
step is here. Thanks for any input.

 

[Marc Soester [MVP]]

Hi Project Server Slave,

I am be able to answer some of your questions.

1. The way to bring in Project Owner etc, is to actually create a Project
custom field and refer to the owner. Then you can move the custom field to
the cube and report against it. ( I have done this in 2003, but not 2007. I
would assume that this would also work in 2007)

2. I dont believe that you have the ability to select "current week" without
actually selecting them manually.

This is certainly a complex view and I am sure you will stuggle as it is to
represent all of this information in one view. Best of luck mate