Ent. Project Code Needed

R

RandyK

Each project in our MSPS DB represents a supported application.
Each application has a "bucket" of money that is allocated to such support.

What I need is to create an Enterprise Project Code or Field that we can
manually enter in the current authorized funding amount for each project (at
the project level). The rest of the reporting will be done outside of MSPS.

The PM or Sys admin (either one) will need to be able to update these
amounts as they change. So we cannot use a drop down list - but rather a
free form numeric field that accepts any amount and can be used in
calculations (SQL).

Is this a doable idea?
 
B

Ben

Hi Randy,
Use an Enterprise Project Custom Field of type Cost. These can be entered
in free format.

They can be used in calculations, but by default, don't go into the OLAP
cube of course.
 
R

RandyK

Perfect! Why would they not make it down to the OLAP? I thought only
task level codes didn't make the OLAP cube.

This is really not a show stopper as the reporting would be done outside of
MSPS - but I am just curious.

Thanks for the tip! Pretty sure this is what I will use!
Randy
 
B

Ben

The design of PS2003 means that, out of the box, only Resource and Project
Enterprise Outline Codes are dimensions in the cube. Enterprise Custom
Fields do not, though there are some 3rd party OLAP extenders that allow this
(or you can extend the cube yourself). With an Enterprise Custom field such
as Cost or Number, you would have to decide whether it should be a dimension
or a measure, though for authorised funding you would probably use this as a
measure.
 
Top