Changing the Data Source name for a cube. - 08-05-2005 , 03:32 PM
Is there a way of changing the Data Source name for a cube. It is easy to
change the contents but the name appears to be write-only. I often devlop
cubes on a machine at home and restore them at work. The end result is that
the data source name always reflects the name of my home SQL Server
installation...I would like to change this if possible to a name which
reflects the client we are developing the cube for.
Re: Changing the Data Source name for a cube. - 08-05-2005 , 07:31 PM
Not directly, but you can copy-and-paste.
The paste operation notices that one already exists with the same name and
prompt you for the new one. Unfortunately, the name is bound to the objects
is creates so you need to name the object *before* you start using it . So I
typically recommend that you give it a logical name based on the kind of
data in the database, e.g. Sales Data, or Inventory Data, so if you move it
to a different server or database name, it still makes sense. See the AS
in the section titled: Data Source Configuration
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Trevor Farley" <tfarley (AT) tpg (DOT) com.au> wrote