Query for extracting multivalue fileds from the reporting database (PS 2007)

D

Dave

Hello all,

Does anyone have a query for retrieving multivalue custom fields from the
reporting database .

Thanks in advance
Dave
 
C

Colby Africa

Hi Dave,

I am looking for an answer to this as well. Have you found anything?

Thanks!

Colby
 
J

Jonathan Sofer

Are you looking for the multivalues reported against projects, resources and
tasks or to return the available values for a multi-value field?

Jonathan
 
D

Dave

I am looking for the values of the multi-value custom field.

For example. Let us assume that there is a custom field "Strategic Area" and
it has the following values in a lookup table
1) Expand into new markets
2) Increase the number of people entering our retail shops
3) Increase market share.

The "Strategic Area" value can be one of the 3 values or it can be
combination so if a user selects 1 and 2, I want to report on the values so
I should be able to get 1 and 2.

How would I go about do that.

Thanks in advance
Dave
 
J

Jonathan Sofer

It is very strange but I tried to query the multi value field and I cannot
find it anywhere in the reporting or published database.

When you create a normal custom field (not multi-value) it creates a column
in the reporting database under MSP_EpmProject_UserView

But when you make it a multi value, it never creates that column.

Sorry I could not find it for you.

Jonathan
 
Top