ps2003 Extending Cube

[GMarquez]

Hi folks,

I am extending my OLAP Cubo of my PS2003

I have made indicated steps in microsoft documents:

1. Extending MSP_VIEW_PROJ_TASK_TP_BY_DAY table
(with the field that I want recording)

2. Extending my ...\Microsoft Office Project Server 2003\BIN\QYLIBSQL.SQL
(with the TaskTime[FIELD] that I want recording in my
MSP_VIEW_PROJ_TASK_TP_BY_DAY table)

I only have extended for registering PERCENT COMPLETE field, the steps are ok.

I am writing data in project server simply using my Project Professional,
changing my "Status Rate", Recalculing the Project, etc, all that you need
for register data when you make Control in your Projects.

BUT,

Data is saved in ...TASK_ENT, ...TASK_STD, ...PROJECT_ENT, ...PROJECT_STD
(tables), etc...

BUT NOTHING is saved in my MSP_VIEW_PROJ_TASK_TP_BY_DAY table

Some suggestion?

 

[GMarquez]

Hi!,

For giving you more information about my issue, I also had followed the
steps that are recomended in the "Bob Seagrest's whitepaper" for extending
OLAP Cube (extend -...BY_DAY table and modify QYLIBSQL.SQL file), I want to
tell you what I wrote in the file, and what I extended in ...BY_DAY table

STEP 1:
=====

Alter TABLE [dbo].[MSP_VIEW_PROJ_TASK_TP_BY_DAY] add
[TaskTimePercentComplete] [decimal](25, 6) NULL,
[TaskTimePercentWorkComplete] [decimal](25, 6) NULL,
[TaskTimeDuration] [decimal](25, 6) NULL,
[TaskTimeFinishVariance] [decimal](25, 6) NULL,
[TaskTimeStartVariance] [decimal](25, 6) NULL

Has field tehe correct structure?

STEP 2:
=====

With that information I have a BIG doubt for the QYLIBSQL.SQL file:

The fllowing fields:

TaskTimePercentComplete,
TaskTimePercentWorkComplete,
TaskTimeDuration,
TaskTimeFinishVariance,
TaskTimeStartVariance

Well are written? ("TaskTime" + [field name]) specifically,
TaskTimePercentComplete, TaskTimePercentWorkComplete and TaskTimeDuration,

Regards!,