C
carl.gherardi
Hey all,
I'm extending a 2003 server with the TaskEarnedValue Portfolio
extension available from Microsoft.
I'm attempting to extend the information available in this query,
initially for a value of remaining work and have come across a snag and
dont know where to be looking.
I've extended the table MSP_VIEW_PROJ_TASK_TP_BY_DAY with the
additional column TASK_REM_WORK and the MSP_CUBE_TASK_FACT table
accordingly, along with modifying the vb code provided that publishes
data to MSP_CUBE_TASK_FACT.
My problem is the modification of the line in qylibsql.sql on the
project server, which (at least to my current undertanding) is used to
publish data to MSP_VIEW_PROJ_TASK_TP_BY_DAY. The query has been to
from:
SELECT ..., TaskTimeREMWork FROM TaskTimePhasedByDay - which of course
doesn't work.
My problem - where do I find TaskTimePhasedByDay, and is it possible to
extend?
Pointers to useful resources appreciated.
TIA
Carl G
I'm extending a 2003 server with the TaskEarnedValue Portfolio
extension available from Microsoft.
I'm attempting to extend the information available in this query,
initially for a value of remaining work and have come across a snag and
dont know where to be looking.
I've extended the table MSP_VIEW_PROJ_TASK_TP_BY_DAY with the
additional column TASK_REM_WORK and the MSP_CUBE_TASK_FACT table
accordingly, along with modifying the vb code provided that publishes
data to MSP_CUBE_TASK_FACT.
My problem is the modification of the line in qylibsql.sql on the
project server, which (at least to my current undertanding) is used to
publish data to MSP_VIEW_PROJ_TASK_TP_BY_DAY. The query has been to
from:
SELECT ..., TaskTimeREMWork FROM TaskTimePhasedByDay - which of course
doesn't work.
My problem - where do I find TaskTimePhasedByDay, and is it possible to
extend?
Pointers to useful resources appreciated.
TIA
Carl G