Custom Fields in DA

[PSU35]

Can anyone tell me how I get a custon field to show up in DA?
Please be specific on the steps.
thanks

 

[Dale Howard [MVP]]

PSU35 --

The Project Server administrator needs to do the following steps:

1. Log into PWA with administrator permissions and then click Server
Settings - Enterprise Custom Field Definition.
2. On the Custom Fields and Lookup Tables page, create a custom Lookup
Table containing the list of values to display in the custom field.
3. 2. On the Custom Fields and Lookup Tables page, create a custom field
and attach the newly-created Lookup Table to it.
4. Click Server Settings - Configuration (in the Cube section).
5. In the Cube Dimensions section of the Cube Configuration page, add the
new custom field to the Selected Dimensions list.

The next time the OLAP cubes rebuild, the new custom field will appear as an
available Dimension in the appropriate OLAP cubes. If you want more
detailed information than the above, you might consider purchasing one or
more of our books on Project Server 2007, available for purchase at:

http://www.projectserverbooks.com

Hope this helps.

 

[PSU35]

Thanks for the reply Dale.
I have a follow up question.
Is it necessary to have a look-up table for the custom field before it will
be available to use in data analysis?
If the field is free form numeric or text field would it not be available?

Also, a little off topic, can you recomend a good book that that covers
project server and specifically data analysis? The books available that I
have discovered seem to be light on the "instructions for users" or "how to"
information.

Again, thanks for the assistance. It is much appreciated.

 

[Dale Howard [MVP]]

PSU35 --

Yes, the custom Task, Resource, or Project field must include a Lookup Table
to make it available to appear as a Dimension in Data Analysis views. If
the field is free entry or contains a formula, it is not available for
inclusion in the OLAP cubes or in Data Analysis views.

Regarding a book, you might consider purchasing each of our books on Project
Server 2007, available for purchase at:

http://www.projectserverbooks.com

You will find that our books are through and provide in-depth information.
One book is specifically for project managers, while the other is
specifically for Project Server administrators. Hope this helps.