Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ToddV
Posting Yak Master
218 Posts |
 Posted - 2002-07-19 : 12:48:54
|
| I created a cube on a development box. By default the Data Source Name (MSSQL2000) displays as "DevServer - DatabaseName". I copied the cube to our QA Environment by copying and pasting the cube in Analysis Manager. I then edited the data source to used the QA database Server. AfterI did this, the Data Source Name still reads "DevServer - DatabaseName" rather than the expected "QaServer - DatabaseName". I can not find a way to change this value. Any help would be appreciated? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-23 : 17:26:11
|
If your cube is empty (which it isn't) you can change the name by copying it (which will prompt a rename) and then deleting the previous one. However if the cube has any structures (dimensions/measures etc) you cannot do this as its hard coded into the cube structure. This is a stupid problem that should have been fixed by now as its only the display name in the GUI that needs to change - maybe in Yukon ? Harass these people [url]sqlwish@microsoft.com[/url] - to be fair this has been discussed in the MS olap newsgroup and some microsoft people have agreed that its something that should be looked at so here's hoping  HTHJasper Smith |
 |
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-11 : 08:16:36
|
 Grrrr! I just got bit by this one, so I can say that as of Service Pack 3a they haven't quite gotten around to it.I understand that by mucking about in the Repository tables you can change the data source's display name, but I'm not risking it. ¡Muy mal, Sr. Gates!--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
|
|
|
|
|
|
Data Source Name