Which table(s) store timephased BW for each task?

C

Connie G

I am interested in reporting on timephased Baseline Work Hours.

I currently use the MSP_Cube_Assn_Fact table for my static, daily reports.
My understanding is that this table gets updated when the nightly OLAP Cube
is run.

Which table contains similar data in real-time (not dependent on Cube).
I've looked at all the MSP_ xxx tables but either can't find it or am unable
to interpret the table. I will need both Baseline Work and Actual Work in
the table.

Thanks in advance for your time.
 
G

Gaurav Wason

"AssignmentTimeBaselineWork" is field and table is
"msp_view_proj_assn_tp_by_day"

**Remember this table will only have the information if the project is
published.

Let me know.
 

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

Which table(s) store the assignment timephased data on server? 2
Entries interpreted as days not hours 4
Query Task Baseline Work out of Timephased Data table 3
Project Server (OLAP) Training Needed 4
Query Baseline Work out of Timephased Data table 1
Pivot Table > Running Total In... > Error 0
Issues with Project Server Installation 0
Combine multiple tables with different date ranges 2

Top