Hi,

I've two DW servers (production, development). I want to make sure that my
development dw server is update with the production. Everynow and then I
change cube details on the production dw server but when I "copy cube from
production to development" or "restore production dw on development dw" a
data source pointing to prodution dw gets created on the development server
and all the cubes are pointing to the production data source. I've changed
the data source details in partitions but when i try to process the cubes it
fails. Also If i edit the cube i can see that priate dimensions are still
pointing to production server. Does the cube need to be processed
successfully to apply data source changes from partions to dimensions?

Or is there any other way to maintain two dw on production and development
sync with each other?

--
Regards,

Vivek

You should not need to edit the connections for individual partitions in
this situation. You only need to change the settings for the shared data
source at the OLAP database level.

Note that you cannot change the name of the data source, so it will most
likely still have the name of your production server, but if you change
the underlying connection details all the objects in the database
(cubes/partitions/dimensions) will use these new details. The only
exception I can think of is if your production database has multiple
connection details for individual partitions, but that would be highly
unusual.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <B57204F5-8EF3-479E-8656-CE4E5741D2FF (AT) microsoft (DOT) com>,
Vivek (AT) discussions (DOT) microsoft.com says...