locked
Rename a cube in SSAS 2008 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have a cube and the dimensions are failing to process because of an "internal error: an unexpected exception occurred". Absolutely no other details.

    Looks like I will have to do a full reprocess of the dimensions again, which means losing all data in the cube.

    I want to rename the cube to something else so that users can still connect to it and retrieve some historical data from it.

    I've read a few posts about this but I'm not clear about how to do it. There are suggestions ranging from right clicking on the cube and selecting rename to the steps I've listed below and other suggestions about changing configuration files and restarting the SSAS service. Maybe all of these approaches are doing the same thing in the background.

    Is it a case of:

    1. right clicking on the database in SSAS in SQL Server Management Studio

    2. Generating an alter xmla script

    3. changing the Name of the database 

    Do I need to change the ID as well?

    I presume that users will then be able to connect to the cube by just selecting the new cube name on the server.

    Many Thanks

    Saturday, April 14, 2012 1:10 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jones,

    Try to generate the alter XMLA script by right clicking on the database and select "Script Datatabase as"->"Alter To"->New Query Editor Window, then, easiy locate the name and ID of the databse and change their value to what you desire. Execute the script after your modification. But i never tried that. I just give it here for your reference.

    Regards,
    Jerry

    • Edited by Jerry Nee Wednesday, April 18, 2012 10:32 AM
    • Marked as answer by Jerry Nee Wednesday, May 2, 2012 10:31 AM
    Wednesday, April 18, 2012 10:29 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    I think you are looking for a snapshot or backup for your current cube. The best way to do so is backup the current cube and restore the backup to a different name. In this case, you can do a full process on either one.
    • Proposed as answer by RichardLees Wednesday, April 18, 2012 12:26 AM
    Saturday, April 14, 2012 11:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I would change the ID as well so that it matches the name of the new database..

    http://blogs.msdn.com/b/sqlcat/archive/2007/07/30/renaming-olap-databases-issues-within-analysis-services.aspx

    Josh Ash

    Sunday, April 15, 2012 11:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jones,

    If you follow Patrick's suggestion (restoring a backup) you won't need to worry about changing the ID.  When you restore the name you give the db becomes the id.

    Richard Lees

    Richard

    • Proposed as answer by RichardLees Wednesday, April 18, 2012 12:26 AM
    Tuesday, April 17, 2012 4:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Many thanks for the responses

    The cube I have is quite large. Instead of backing up the cube and restoring it with a different name, I'd prefer to rename the existing cube and then deploy another cube with the original name. Not sure if the renaming the existing one is possible though? The redeployed cube would become the production cube going forward so I wouldn't want the renamed cube using the old ID.

    Thanks

    Wednesday, April 18, 2012 1:58 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jones,

    Try to generate the alter XMLA script by right clicking on the database and select "Script Datatabase as"->"Alter To"->New Query Editor Window, then, easiy locate the name and ID of the databse and change their value to what you desire. Execute the script after your modification. But i never tried that. I just give it here for your reference.

    Regards,
    Jerry

    • Edited by Jerry Nee Wednesday, April 18, 2012 10:32 AM
    • Marked as answer by Jerry Nee Wednesday, May 2, 2012 10:31 AM
    Wednesday, April 18, 2012 10:29 AM