Hi Lowell, I agree, the following will give Catalog Name:

SELECT * FROM openquery([SSASLocal], 'SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS')

Method 1:

If you connect to Analysis Services via SSMS, then right-click on the Analysis Services database, then left-click on Properties, you will get the Name and ID (ID is same as Name). You will notice you can change the Name but not the ID. Make a backup of the Analysis Services database first. Open Visual Studio project, right-click the Cube and left-click View Code. The second line will list <ID>CubeName</ID> , here you can change the ID , then click Save All, then Build Project, then right-click the Cube and left-click Process.

-------------------------------------------------------------------------------------------------------

Method 2: (recommended)

Backup your SSAS database via SSMS ( Analysis Services ) using below query:

<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>CocaCola</DatabaseID>

</Object>

<File>D:\CocaCola.abf</File>

</Backup>

Right-click your database and click Delete.

------------------------

Restore the SSAS database you deleted via SSMS ( Analysis Services ) using below query , ( to change name Replace 'CocaCola' with 'Fanta' ):

<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<File>D:\CocaCola.abf</File>

<DatabaseName>Fanta</DatabaseName>

</Restore>

Right-click Databases, left-click Refresh.