Hi,

I have copied the database db2k1 to db2k2, and it has taken the same
datasource for db2k2 as it was for db2k1, how can I rename the datasource,
Also I wanted to know, can I reset the datasource for already created cubes,
if yes then how ?


Thanks,


Ia

Unfortunately, you cannot change the name of a data source. You can change
the underlying server and database name. But not the name of the data source
object. What I typically recommend is that, before you start creating
objects, you rename the data source (actually cut and paste, then give the
new copy a different name) to a "logical" rather than physical name. The
default data source name is <server>-<database>. Instead rename it to "Sales
Data" or "Inventory Data" and then build objects off of that.

AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
see the section on data source configuration.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"a" <a@a.com> wrote