Delete a Multidimensional Database or Cube (Analysis Services)
You can use SQL Server Management Studio to delete an existing Microsoft SQL Server Analysis Services 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.