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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With