EPM 2007 report

[idvr]

I want to create a report (ssrs). I've read in MSDN that the 2007
version has a special database for reports to use and all other DB's
might change when installing fixes and service packs so its not a good
idea to use them for the reports.
I need my report to be based on a lookup table created by the user.
Does this table reflects in the reports DB?

 

[Jack Dahlgren MVP]

If you have the lookup table built in the enterprise global it should be
available in the reporting database.
This is assuming you are using project server. If you are not using project
server, then there is no reporting database available.

-Jack Dahlgren

 

[JulieS]

Just a quick point of clarification for the Project client. I
believe the details from a project file made only with the project
client are available through the Visual Reports > Save database
command. I use that command to create custom reports from Project
2007 through Access 2007.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[idvr]

Thanks for the answers
I can see the values I've entered to the lookup table in th
msp_empLookupTable. I can also see the custom field using the projec
server application > tools>customize>fields (the fields is marked a
enterprise).
The problem is when viewing the msp_emptask_userview I can't see th
field although it should be ther
http://technet.microsoft.com/en-us/library/cc721700.aspx. Is there a wa
to refresh the RDB

 

[idvr]

I know understand its because the field is multivalue. Where does th
RDB stores the selected values for each task

 

[idvr]

I found the answer:
from MSP_EpmTask tasks
inner join MSP_EpmCustomFieldAssociation multi ON multi.EntityUID
tasks.TaskUID
inner join MSP_EpmLookupTable LT on lt.memberuid
multi.lookupmemberuid

the EpmCustomFieldAssociation table is the cross reference tabl
between the tasks and the lookup table value