This knowledge base article outlines how to delete an OLAP cube database instance in MicroStrategy Developer
Follow the steps below to delete an OLAP cube database instance from Strategy Developer
Go to Schema and open the OLAP Cube Catalog.
Select the database instance to delete.
Remove all the selected cubes by right clicking on them and selecting the Remove option as shown in the image below:
If there are no reports that use that cube, it will be removed successfully. If there are reports that use it, the following error will occur:
In order to find which reports use the OLAP cube, go to the Data Explorer for the Database Instance that needs to be deleted, right click on the cube, and select 'Search for Dependents' as shown in the image below:
This will return a list of reports that use that OLAP cube.
Delete these reports and then reattempt to remove the cube from the OLAP Cube Catalog.
Uncheck the database instance from Project Configuration > Database Instances > OLAP Cube to remove it.
In the Administration menu, go to Projects and then select to 'Delete unused managed objects'. It is important to backup the metadata before performing this final step.
This issue has been logged as Scopus ID: 373258 and KB ID: 000017795
