I have migrated my cube to a new server. But when I process the cube, it
still points to source data on original server. How can I change cube data
source, so cube can use new server as data source? Do I have to re-create all
dimensions on new server?

Thanks in advance.

its not so complicated:

change the connection data source using the analysis manager (AS2000) or the
management studio (AS2005) (under the Data sources tree node of your
database)



"Mike Torry" <MikeTorry (AT) discussions (DOT) microsoft.com> wrote

In article <233CA1CC-8DD7-4F57-82C0-F6C9B1FFD0DB (AT) microsoft (DOT) com>,
MikeTorry (AT) discussions (DOT) microsoft.com says...
the connection details in the data source.

Note: that in AS 2000 the connection object will still be named after
the original server and there is no way to change this within Analysis
Manager, but the underlying connection details are the important bit.

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

I use AS2000, when I right click the data source and ‘Edit’ an error occurs
‘Unable to edit data source. No se encontró el proveedor especificado. Es
posible que no esté instalado correctamente.’
How can I change my data source? The old one is using SQLNCLI.1 Provider


"Darren Gosbell" wrote: