dbTalk Databases Forums  

Change DataSource in MS AS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Change DataSource in MS AS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Oleg Korchak
 
Posts: n/a

Default Change DataSource in MS AS - 08-18-2003 , 06:30 AM






Is it possible to change Data Source for existing Cubes and Shared
Dimensions?
How can I do it?
Thank you.



Reply With Quote
  #2  
Old   
Lutz Morrien
 
Posts: n/a

Default Change DataSource in MS AS - 08-18-2003 , 06:45 AM






You can change the datasource by altering the
corresponding connection entries in as manager.

This will only work if your new connection is identical
to the old one concerning given Cube and dimension
definitions.

Note that for some reason it is not possible to change
the name of the datasource itself. (You can change
directly it in the as repository, if you are willing to
get into the database structure).
You also cannot create a second datasource and switch the
two sources.

HTH Lutz

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.