Which table(s) store the assignment timephased data on server?

[Connie G]

I am interested in reporting on timephased data.

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.

Thanks for any help you can provide.

 

[Jag]

Hi Connie,

The table that stores time entered by resource is MSP_WEB_WORK. The table
that contains information on Resource Manager approval is
MSP_WEB_WORK_APPROVAL. You will have to map it to MSP_WEB_ASSIGNMENTS to get
the project id and task information. Hope this helps.

Jag.

 

[Connie G]

Thanks for your response Jag.

Unfortunately, I need both Actual Work and Baseline Work for these reports.

I would love to find the table that populates the 'right' (timephased) side
of the Task Usage view.

Any additional ideas?

Thanks again for your response.
Connie