Restore of database to different environment

[Jim]

Recently, we restored our database from Production to our
Development environment. After the development database
was used for training, we found that thenew projects in
development were not being reflected in the OLAP cube and
was pointing to the Production OLAP cube.

I understand that there is a utility to change this and
other pointers when a restore of the database is made to
another environement.

Anybody know where I can find this utility?

Thanks

Jim

 

[Gary L. Chefetz \(MVP\)]

Jim:

After restoring the database to a different server, go to PWA Admin, Manage
Enterprise Features and set the cube name and server appropriately and build
the new cube. Then, open each Analyzer view and point it to the correct
cube.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-

 

[Jim]

Hi Gary.....

Thanks for the info...

But not to seem dense, but where do I navigate to get to
point the Analyzer view to point correctly.

Thanks

Jim

 

[Gary L. Chefetz \(MVP\)]

Jim:

I the modify view page, you can specify the cube name. If you're using 2002,
you need to do this in the database.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-