Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

changing the ID of an SSAS database

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.

like image 266
Raj More Avatar asked Nov 29 '22 19:11

Raj More


1 Answers

By some miracle, I found this. If you click a little button at the top of the Solutions Explorer in Visual Studio that says 'show all files' when you roll over it, you will see a file called Something.Database. View the code of that file and you can edit an element. This will change the ID of the database on deployment.

like image 140
Adam Gilmore Avatar answered Dec 09 '22 15:12

Adam Gilmore