Negative Baseline Costs

W

WRT IT Dept

I'm trying to develop a cash flow report against a virtual cube -
MSP_Project_Timesheet. Everything works great. However, when posting
negative baseline costs in MS Project 2007 it doesn't post
MSP_Project_Timesheet. It posts the changes to the Assignment Non Timephased
cube. It appears positive baseline costs show up correctly in
MSP_Project_Timesheet. I've downloaded the SDK and I'm currently looking at
the OLAP schemas for more information. Any help in the right direction would
be greatly appreciated.
 
W

Wharton Computer Consulting

I am assuming that if you have downloaded the SDK, you are using Visual
Studio. If not, then import the cube into Visual Studio 2008 (2005 works,
but 2008) has more features and wizards, and you will see the schema (OLAP
design, measures and dimmensions)
 
W

WRT IT Dept

Thank you for your response, allow me to clarify:

If I open a project in Project Desktop, I can enter a negative value for the
cost field for a certain task.

I can save and publish the project, and any PM can open the project in
Project Desktop and see the negative value in the cost field for that task.

However, if I rebuild the cube, and look at the Cost field for that task in
that project in the MSP_Project_Timesheet view, I do not see the negative
cost. The cost shows up as 0. Note this behavior is only for negative costs,
positive values in the cost field for the task come through fine.
 

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

Top