Enterprise Custom Field in the OLAP Cube

[Jesse]

I'm using Project Server 2007. I've created some enterprise custom task/text
fields, created a project and entered data into these fields, and re-built
the cube. One custom field has a lookup table with 5 values to select from
(not multi-select). I want to create a data analysis view and filter on the
values in this custom field. I cannot locate any custom fields (text,
project, resource) in any of the cubes. What am I doing wrong, where am I
able to see the custom fields in the cubes?

 

[Dale Howard [MVP]]

Jesse --

Log into PWA and then Server Settings - Configuration (in the Cube section
of the page). On the Cube Configuration page, select the Project, Resource,
and Task custom fields you want to include in the OLAP cube. As you can
see, this doesn't work the way it did in Project Server 2003. Hope this
helps.

 

[Projectability]

Jesse,

In addition to Dales advice try to avoid defining custom fields with a
numeric lead, for example 1_Region, 2_Sector - I have seen clients where
they have done this to "promote" their custom fields to the top of the list
which is achieved using numeric characters but the OLAP cube configuration
does not like this naming convention. I have not checked to see if * has the
same results but would imagine it probably does.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==

 

[Jesse]

Thanks Dale, that did the trick!
--
Jesse

Jesse --

Log into PWA and then Server Settings - Configuration (in the Cube section
of the page). On the Cube Configuration page, select the Project, Resource,
and Task custom fields you want to include in the OLAP cube. As you can
see, this doesn't work the way it did in Project Server 2003. Hope this
helps.

 

[Dale Howard [MVP]]

Jesse --

You are more than welcome, my friend!