How do you copy and paste an SSAS 2005 cube from one database to another.

Copy and paste is a great SSAS 2000 functionality that allows us to quickly
make copies and test changes. Can we do the same in 2005? if so how? if not
why the heck not?

N.B I'm using the microsoft freebie "SQL Server 2005 - personal edition".

you can create the XML/A commands to create the new database.
(right click on the original then go to the right submenu)

"HWUK" <HWUK (AT) discussions (DOT) microsoft.com> wrote

I've tried that but it dosn't copy the dimensions or datasourse. I want to be
able to copy a cube paste it in a different database and process, I dont want
to have to script out every object individually and then script it back in.
Is this a huge oversight by microsoft of developers needs?

"Jéjé" wrote:

If you want cubes, data sources and diemnsions, then script out the
database.
Jéjé is absolutely right -- you use scripting to implement the same
functionality as cut-paste.

Getting similar functional to Analysis Manager was not possible since there
is no similar technique with SQL Server RDBMS. This is one of the areas
where the merging of the AS and RDBMS tools (such as SSMS, Profiler) hurt
us -- but there are lots of areas where the merging helped us, e.g. the
entire scripting subsystem, being able to administer AS right next to its
RDBMS data source, SQL Profiler support, MDX color coding in SSMS, etc.
--
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.


"HWUK" <HWUK (AT) discussions (DOT) microsoft.com> wrote

If you are developing using a solution/project in BIDS you can also go
into the properties of the solution and change the deployment target
database and/or server/instance. You could either make a copy of your
solution before making changes, or if you have a source code control
system you could use that to maintain the various "releases" of the
database.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <O0K0wFmLGHA.532 (AT) TK2MSFTNGP15 (DOT) phx.gbl>,
dwickert (AT) online (DOT) microsoft.com says...

Dave,

Thanks for the reply.

Unfortunatly this isn't what I was hopeing for, if I have a database with 20
cubes in and I want to amend only one of them, I don't want to have to copy
the entire database, it's unnecessary and takes longer.

I appreciate all the effort you guys have gone to and I'm sure theres a
reason why when you script out a cube SSAS dosn't look for associated objects
and script them at the same time, but I'm disapointed to say the least that
this killer function isn't available. To me, and I'm sure many others out
there, It would be like rewriting Outlook and saying "sorry guys, but in the
new version you can't forward emails" or rewriting work and saying "yes you
can copy and paste, unfortunatly the paste will only paste back 30% of your
text, oh and yes, you'll lose the formatting"

"Dave Wickert [MSFT]" wrote:

Thanks for that Darren, I'll give it a try going forward. At the moment the
cubes I have are migrated from AS 2000 and arn't part of any solution or
project, so I've been looking at ways to do it in Management Studio.

"Darren Gosbell" wrote:

In BIDS go File -> New Project, and in the Business Intelligence project
types there is an option to import Analysis Services 9.0 Database. This
will let you create a Solution from your migrated database.

HTH

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <58DBE05A-A2FC-47A8-BE77-39440DFC519A (AT) microsoft (DOT) com>,
HWUK (AT) discussions (DOT) microsoft.com says...