Location of Enterprise Custom Fields

[dj_mac]

I have created an Enterprise Custom Field called B_Project Type. I am looking
to use it as a reporting criteria in SQL Reporting Services.

My question is what table are Enterprise fields stored in?

Any assistance is appreciated.

Doug

 

[Chak]

Hello Doug,

Please look for dbo.MSP_EpmProject_UserView in Reporting database
under Views. You will see the Enterprise custom columns here.


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com

 

[dj_mac]

Chak,

Is this only held in a "View" or is it in an actual table entity?

Thanks,

 

[Chak]

Hello Doug,

I am not sure, why you want to go the tables, when
dbo.MSP_EpmProject_UserView is perfect for SQL query. Tables in
reporting database doesn't have custom filed info. You have to get the
info from this view only.

Offcourse, the original data is located in Draft/Published databases.
Data is spreaded across multiple tables like "MSP_Custom_Fields,
MSP_Project_Custom_Fields, MSP_Lookup_Tables and
MSP_Lookup_Table_Values". It is complex process to query the info from
these tables. If you want, you can use your SQL Query skills to
dervie the info by joining all these tables The other side note
is, Microsof recommends not to have data manipulation queries from
draft/published databases.

Reporting database is completely denormamized and contanis user
friendly schema. I hope, this will help meet your needs.


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com

 

[dj_mac]

Thanks Chak........

Hello Doug,

I am not sure, why you want to go the tables, when
dbo.MSP_EpmProject_UserView is perfect for SQL query. Tables in
reporting database doesn't have custom filed info. You have to get the
info from this view only.

Offcourse, the original data is located in Draft/Published databases.
Data is spreaded across multiple tables like "MSP_Custom_Fields,
MSP_Project_Custom_Fields, MSP_Lookup_Tables and
MSP_Lookup_Table_Values". It is complex process to query the info from
these tables. If you want, you can use your SQL Query skills to
dervie the info by joining all these tables The other side note
is, Microsof recommends not to have data manipulation queries from
draft/published databases.

Reporting database is completely denormamized and contanis user
friendly schema. I hope, this will help meet your needs.


Thanks
Chak
pVector Technologies
http://www.pvectortech.com
http://www.epmcentral.com