none
Want to replicate a cube in the same server

    Question

  • 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?

    Thanks!

    Wednesday, September 18, 2013 8:24 AM

Answers

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.

    http://www.bifeeds.com

    • 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: http://technet.microsoft.com/en-us/library/ms174874.aspx

    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