Hello,
In SSAS 2005, how can I copy a cube from one database to other one?

Thanks,
GB

In AS 2000, Copy and paste is very helpful. I did not find how to same
function exactly in AS 2005 yet.

But it is possible to copy a cube from one database to other one through
several steps in BIDS.

First, add projects for each database respectively.
Next, copy a cube from one database and paste it to another database in
Solution Explorer.
In this time, the dependent objects such as data source, data source view,
dimensions are not copied automatically.
You also copy them manually.

If someone has more good way, let me know it.

Ohjoo


"GB" <v7v1k3 (AT) hotmail (DOT) com> wrote

You can use Script Cube As | Create to and execute that script in different
database.
OR you can use AMO (Analysis Service object model). Clone the object in
code.

You need to copy DataSource and DSV objects as well.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Ken Kwok
SQL Server Analysis Services

"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote