changing the ID of an SSAS database

Question

I want to rename my SALES cube to SALES_2009 and put a new cube called SALES. When I rename it, the ID remains as SALES so my new cube now is called SALES, but it's internal ID is SALES_2010 (and my old cube is called SALES_2009, but the internal ID is SALES).

Can the ID of a SSAS database be changed?

I have tried the properties window and googled bing, but to no avail.

Answer 1

You could backup and restore with new name - http://richardlees.blogspot.com/2009/05/new-analysis-services-database-version.html but there isn't any way to alter the databaseid AFAIK

Answer 2

In the past I've scripted the cube as a create statement to a new window, changed the IDs to what I needed, dropped the old cube & run the create script. It works, but seems a bit risky.