How to: Delete an Analysis Services Database or Cube
You can use SQL Server Management Studio to delete an existing Microsoft SQL Server 2005 Analysis Services (SSAS) object, such as a database or a cube, on an instance of Analysis Services.
To delete an Analysis Services database
Connect to an Analysis Services instance.
In Object Explorer, expand the node for the connected Analysis Services instance and ensure that the object to be deleted is visible.
Right-click the object to be deleted and select Delete.
In the Delete Object dialog box, click OK.
See Also
Other Resources
Administering Analysis Services in Management Studio How-to Topics