Old OLAP data after copy database, editsite, pscleaner, importprojects, build new cube

Z

Zappa

To create an extra environment for the customer, with the same
settings as the current, I took the following steps:

- copy ProjectServer database to 'ProjectServer0809'
- create a Project Server Site using editsite, called it
'ProjectServer0809'
- delete all Enterprise Projects and Resources using PSCleaner tool
- delete some enterprise projects which still showed up in 'Clean
Database' in PWA/Admin
- import projects
- build a cube with a new name ('Default0809')

To my surprise, this Cube shows data from the previously deleted
projects.
What did I do wrong?
How can I correct my mistake?

Kind regards ...
 
R

Ray McCoppin

Assumming that the SQL server and Analysis Server remained the same. You
need to change the names of the OLAP cube in each one of the Portfolio
Analyzer Views on the PWA admin page.

Hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
SQL Reporting Services Reports with Gantt Charts
Project Server 2003-2007 SQL Reporting Services Reports
 

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