Archiving off closed projects

R

Randy

I'm looking for a procedure to follow to archive closed projects off of our project server. However, I still need the data available for our olap cube. We are running project server 2002. Thanks!
 
D

Dale Howard [MVP]

Randy --

You can't have it both ways: you can't remove a project from the Project
Server database AND have it appear on the OLAP Cube. If you need to
indicate that a project is closed while it is still in the Project Server
database, then you could create a custom enterprise project outline code
field containing values such as Planned, In Progress, On Hold, and Closed,
for example. When you publish your projects again, this custom enterprise
project outline code field will become a dimension in the OLAP Cube, and can
be used for Filtering and Grouping in Project Center views if you include
the field in the Views. Just an idea. Hope this helps.




Randy said:
I'm looking for a procedure to follow to archive closed projects off of
Click to expand...
our project server. However, I still need the data available for our olap
cube. We are running project server 2002. Thanks!
 
R

Randy

Makes sense. What management is wanting done is to clean up the server by removing projects while retaining actuals for the cube. Could this be done by dumping information (such as hours) into a spreadsheet and then tying to the cube?
 
Top