Data Analysis View

[jeff.naftzger]

Hi all,

I have created a enterprise custom field for task status. The
enterprise custom field points to an outline code with the different
status. I also have another enterprise custom field and outline code
for task type. I created a cube with both custom fields as cube
dimensions, but when I go to create the view I don't know how to get
their respective counts per respective outline entry. Do I need to
create a measure field ? If so how do I do that ?

example

status high med low
type major 3 2 1
type minor 5 5 3


Thanks

Jeff

 

[jeff.naftzger]

Hi all,

I have created a enterprise custom field for task status. The
enterprise custom field points to an outline code with the different
status. I also have another enterprise custom field and outline code
for task type. I created a cube with both custom fields as cube
dimensions, but when I go to create the view I don't know how to get
their respective counts per respective outline entry. Do I need to
create a measure field ? If so how do I do that ?

example

status high med low
type major 3 2 1
type minor 5 5 3

Thanks

Jeff

I forgot to mention that I am using Project Server 2007 with SQL
Server 2005.

Jeff

 

[jeff.naftzger]

I forgot to mention that I am using Project Server 2007 with SQL
Server 2005.

Jeff

I fixed my problem. I had corrupt project that was causing the cube to
not correctly calculate the custom fields.