Viewing Calc. Text Fields in PWA & MSProject But not in DB

B

BayerWhite

Calc. Text fields can be seen in PWA and MSProject because they both use the
formula to calculate the field, however this value is not in the
MSP_TEXT_FIELDS table until the project is actually saved using PWA or
MSProject.
My group was trying to bounce the calc. text value to a outline code to be
viewed in the OLAP cubes, yet I could not get the calc. value from the db
that PWA and MS Project was showing.
 
R

Rod Gill

Nothing gets updated in the database until a project is saved, PWA posts
timesheets or the project is published.

Try the MSP_VIEW tables for reporting purposes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Discrepencies between the OLAP Cube and the MS Plan 4
Custom PWA Field in My Timesheet Cannot Be Queried 1
Sync between PWA-view data and data in the project data base 1
Can't connect to OLAP cube anymore 1
Enterprise Custom Field (ECF) with formula - #Error 10
How to Update Task Level Enterprise Custom Fields in PWA 1
Externally added Text Field not visible in PWA 0
Calculated Field in Pivot Table 1

Top