I haven't been able to find anything on this but is there a way to copy a cube within Visual Studio 2008?
I want to make changes to a cube but the only system access I have is to a production system and I would like to make a custom version of the cube without changing the model version. Thoughts?
Thank you in advance, John
This is usually not done in Visual Studio, but using Sql Server Management Studio.
Connect to the SSAS server using Sql Server Management Studio.
Right click the OLAP database name and script it out as XMLA.
Change the Database Id and Database Name (lines 5 and 6) to MyOlapDb_New
Deploy the script (press F5)
Now you have a copy that you can play with.