is there a db schema for msps 2007?

S

Shawn Everingham

Looking for a db schema for msps 2007....does one exist? thanks again! Shawn
 
S

Shawn Everingham

fantastic! I haven't looked at it, but am so thankful for a responsive
community. If this link isn't what I need, I'll post another response.
Thanks!!!!!
 
S

Shawn Everingham

Marc,

I did not find the Resource Employee ID anywhere in that schema...am I
missing something?

Thanks Marc! Shawn
 
S

Shawn Everingham

no wonder I can't find it...it is a custom field we created. How do I get a
handle on Custom Fields? where are they located? thanks again!
 
M

Marc Soester [MVP]

Hi Shawn,

if the Custom field is a number field, then you should be able to include
this in your cube.
Check out if you can see the custom fields in the cube configuration (
Server Settings > Cube)
Let me know if you can see this as a measure
Thanks
--
Marc Soester [MVP]
National Manager: EPM
http://marcsoester.blogspot.com
 
G

Gérard Ducouret

Shawn,

Custom fields, like standard fields, can be found in the syscolumns of the
Reporting database.

Gérard Ducouret
 
Top