Want to replicate a cube in the same server


  • Hi everybody!

    I want to replicate a cube on the same server, just change the name... is it possible?

    If it is... how can I do it?


    Wednesday, September 18, 2013 8:24 AM


All replies

  • Script out the cube , xmla create script. Replace the cube name and cube id with the new name you want to give and execute the same. If you want a new database for this cube then script out the entire database and only replace the database name and database id and execute the script.

    • Proposed as answer by Dotun Adeagbo Wednesday, September 18, 2013 5:10 PM
    Wednesday, September 18, 2013 9:39 AM
  • Ok! I'll try it, thanks!
    Wednesday, September 18, 2013 11:34 AM
  • Hi Menri,

    We can also backup the SSAS database and then restore with a new database name. For more information, please see:
    Backup and Restore of Analysis Services Databases:

    Best Regards,

    Elvis Long
    TechNet Community Support

    • Marked as answer by Menri Thursday, September 19, 2013 2:50 PM
    Thursday, September 19, 2013 8:48 AM