Hi,
I have a cube in sql 2005, I would like to make a copy of that cube with all
the dimensions in the same server with another name so I can point it to
another datasource and then re-process it.

How can I do this? I am fairly new to this and I would really appreciate if
you can tell me in detail.

Thanks in advance

Easiest way is to backup the whole AS database and restore to another
machine.

Or, you can start management studio and right click on your cube and
select "script cube as"->"create to"->"new query editor window". Copy
and paste the xmla script generated for you by AS and run on the target
sql server.

Chu

Mike wrote: