I am getting this error message when copy/paste cubes from
OLAP Server Dev to OLAP Server UAT:

"Could not paste cube 'CUBENAME'. The target database has
a data source, 'SERVERNAME - APPL_NAME', that has the same
name as the data source for the source cube, but some
connection string properties are different. Each data
source used in a database must have a unique name within
the database."

How else would I be able to migrate OLAP cubes I have
created in my OLAP Dev Server to my OLAP UAT Server?
Please don't tell me I have to re-create each cube in the
OLAP UAT Server!

Currently, both servers have Analysis Services 2000 are
installed.

PLS HELP!

See the section titled "Release Management" in the Analysis Services
Operations Guide.
http://www.microsoft.com/technet/pro.../anservog.mspx
It might have some material to assist this activity. Notably the discussion
of (and pointer to) the DSO/XML utility.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Steven Wong" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi All,
I have cubes in my local machine. Now I need to replicate them in the
production server which is a remote machine. Please tell me how to
copy the
OLAP cube from my machine to the production machine. Please give me
the steps to do that.

Thanks in Advance
Prasanna

See the section titled "Release Management" in the Analysis Services
Operations Guide.
http://www.microsoft.com/technet/pro.../anservog.mspx
It might have some material to assist this activity. Notably the discussion
of (and pointer to) the DSO/XML utility.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Prasanna" <prasanna_b2001 (AT) yahoo (DOT) com> wrote

Hi Dave:

The articles do not address migration of new OLAP cubes
between existing AS databases.

I need to move the new OLAP cubes from my dev AS database
over to my UAT AS database, but is getting this
message "The target database has a data source name that
has the same name as the datasource for the source
cube..." when I copy the new OLAP cube over.

It seems like the following are my only options:
1) Delete the AS database on UAT server, and recover an
archive copy of the AS database from dev server with all
the new OLAP cubes on the UAT server.
2) Manually re-create all the new OLAP cubes on my UAT
server. (Would hate to it over when migrate to production!)

Does Microsoft has any other options? Any advice will be
very much appreciated.

Thanks in advance.

Can you be more specific? When you say "move" your cube from dev to
production, what do you mean? What technique are you using?
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Steven Wong" <anonymous (AT) discussions (DOT) microsoft.com> wrote

When I say "move", I was trying to copy/paste the new
cubes from dev Analysis Services (AS) server to UAT AS
server. Both data source names are the same in both AS
server except they are pointed to its own respective
underlying SQL database.

Did that help?

Hmmm..

So I did the following to try and reproduce the problem.
I cut and pasted Foodmart 2000 to Foodmart 2000 Test.
In Foodmart 2000 Test, I deleted the HR cube and all of the mining
models/dimensions.
I processed the database. Everything processed clean.
Now the only difference between Foodmart 2000 and Foodmart 2000 Test is that
the HR cube is missing in Foodmart 2000 Test.

I then cut & pasted the HR cube from Foodmart 2000 to Foodmart 2000 Test.
Everything went OK and then I could process the HR cube without any
problems.

How is that different from your scenerio? Anything different?
The only thing that I can think of is that it is on the same machine.

1) can you try the above and see if the same thing happens on your machine
2) can you try your scenerio but have both databases be on the same machine

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

"Steven Wong" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I tried your scenario and it works fine. My real scenario
differs from your scenario in that: 1) The AS database
NAME and data source NAME are the same in dev server and
uat server, but the underlying SQL database differs. 2)
Copy/pasting in 2 diff servers.

I tried your #2 using my AS dbname1 on my dev machine. I
copy/pasted a new AS dbname2 (obviously, need a new name)
into the same dev server, then, deleted a couple of cubes
from the AS dbname2. Then, I copy those same cubes from
the AS dbname1 and pasted them into AS dbname2, and they
work fine.

Any further thoughts why it still won't work in my real
scenario?

Sorry. I have no idea.
It appears to be working properly on the test scenerios.
You might consider openning up a PSS case as what you are doing *should* be
working properly from the description you've given so far.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Steven Wong" <anonymous (AT) discussions (DOT) microsoft.com> wrote